Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

MariaDB is based on MySQL and is available under the terms of the GPL v2 license.

It's developed by the MariaDB community with Monty Program Ab as its main steward.

MariaDB is kept up to date with the latest release from the same branch.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert databases to switch to MariaDB. MariaDB is a true drop in replacement of MySQL! Additionally, MariaDB has a lot of nice new features that you can take advantage of.

See the MariaDB FAQ for more information.

See also:

837 questions
0
votes
0 answers

MariaDB, TLS and localhost connection

I have a CentOS 8 with MariaDB (10.3.17). The server is setup with TLS and I have configured the server to use 2-Way TLS, following the MariaDB examples:…
ptselios
  • 41
  • 1
  • 6
0
votes
1 answer

MariaDB on CentOS 8 and TLS difficulties

I have a MariaDB Server on a CentOS 8 machine (mariadb-10.3.17) and a client (openSUSE Leap 15.1) with mariadb 10.2.31 I have configured the server with TLS as follows: [mysqld] ... ssl_cert = /etc/pki/tls/certs/dbsrv.example.com_crt.pem ssl_key =…
ptselios
  • 41
  • 1
  • 6
0
votes
1 answer

Import of .SQL file is very slow with HeidiSQL

I have a database on a MariaDB server that I need to copy on a Galera Cluster on other machines. I used HeidiSQL to create a dump file which is pretty fast actually. The database is about 500Mb. However, when I tried to import it on the other server…
Ror
  • 321
  • 3
  • 16
0
votes
0 answers

Failing to Start MariaDB on Ubuntu 18.04 - missing SSH key or bad login information?

I have just installed MariaDB on a new Ubuntu 18.04 box. When I attempt to start the server, I get this: sudo /etc/init.d/mysql start [....] Starting mysql (via systemctl): mysql.service Job for mariadb.service failed because the control process…
jason_frg
  • 1
0
votes
1 answer

Solved 'ERROR 1054 Unknown column' importing into MariaDB 10.4

I recently tried to migrate a database from an old Debian 8, MariaDB 10.1 server to a new Debian 10, MariaDB 10.4 but met with this nasty error ERROR 1054 Unknown column 'pusername' in 'field list' I tried to import the same sql into a Debian 10,…
Gagan Pal
  • 33
  • 7
0
votes
1 answer

mariadb galera cluster, resync nodes behind

I've followed this tutorial, and have a 3 server cluster set up behind a NGINX reverse proxy. https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-on-ubuntu-18-04-servers I can create a database or table…
MrPHP
  • 163
  • 8
0
votes
0 answers

MariaDB Temporal Data Table does not work with ODBC PowerBi

We have a Power Bi file that connects to our MariaDB for data using MySQL ODBC connector. Yesterday we noticed that it can't find one of the required tables in the database, and after some digging we found out, that the table has system versioning…
nyoatype
  • 65
  • 1
  • 9
0
votes
1 answer

several times Mariadb failure

I have vps with mariadb installed on centos 7 the problem is mariadb keeps crashing I've tried so many solutions but no good answer fixes my issue here is my tail -60 mariadb.log Server version:…
Eiaddar
  • 1
  • 1
0
votes
2 answers

Cannot connect to AWS RDS MySQL from local computer with macOS

I'm new to database administration and trying to connect to an AWS RDS MariaDB 10.3.20 instance from my Macbook (10.14.6) on a home network -- having no luck. My understanding per other questions and documentation is that I need to make the RDS…
user
  • 103
  • 1
  • 5
0
votes
1 answer

Netdata logs everything to mysql logs

Since I enabled mariadb logs for all queries on my server, using Netdata shows me each second these queries: SHOW GLOBAL VARIABLES LIKE 'max_connections' 11 Query SHOW GLOBAL STATUS 11 Query commit I have to say it's not helping me to…
zeflex
  • 101
  • 2
0
votes
2 answers

MariaDB 10.3 per thread memory usage and low CPU utilization

I am a bit unsure why we are seeing these memory numbers while the cpu usage is actually very low. -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY…
Josua Blirup
  • 1
  • 1
0
votes
0 answers

MariaDB case sensitive Unicode collation

I see no %_cs Unicode collations in MariaDB (10.3.21, Debian). But I do need to have case sensitive primary key column where 'a' != 'A' (I'm migrating tables from MySQL). Is it not supported in MariaDB? How can I achieve my needs?
spajak
  • 101
  • 1
0
votes
1 answer

Can't Log Into any Virtual User on IMAP (Dovecot) Server: pam_authenticate() failed, unknown user

NOTE: Some of this post contains potentially sensitive information that I've censored out. If you see random piles of asterisks anywhere, that's why. I'm trying to create an email server using Postfix, Dovecot, MariaDB on a cloud instance running…
Sea Jay
  • 101
0
votes
3 answers

CPU - 16 threads stuck at 100% [resolved]

I use centos 8, mariadb 10.5, php 7.4 enter image description here As you can see 16 threads are at 100% stucked there this very unsual normally my cpu are at 10-25% as constant. here is a top image enter image description here What is going on here…
Wed
  • 15
  • 9
0
votes
1 answer

Cannot create or delete db on Plesk server

Today I came to the realization that I cannot add or delete any of the databases that belong to any of my clients on my Plesk server. I had been receiving this error: Error: Unable to remove some of the selected databases. The user specified as a…
stevland
  • 165
  • 10
1 2 3
…
55 56