Server Fault
Server Fault

Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM). The MariaDB tag is for versions 10.6 LTS, 10.11 LTS, and 11.4 LTS or higher.

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:

916 questions
42
votes
3 answers

Increasing nproc for processes launched by systemd on CentOS 7

I have successfully increased the nofile and nproc value for the local users, but I couldn't find a proper solution for the processes launched by systemd. Adding max_open_files to the MariaDB configuration doesn't help. su - mysql to change the…
amq
  • 743
38
votes
6 answers

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep maria mariadb.x86_64 …
danneth
  • 995
32
votes
6 answers

MySQL (MariaDB) Not Starting

I am running Arch Linux 4.8.4-1 on a 64bit installation. I installed MariaDB via pacman. When I try to start it with systemctl start mysqld, it gives me Job for mariadb.service failed because the control process exited with error code. See…
Pranav Nutalapati
  • 439
32
votes
1 answer

Is MariaDB a secure replacement for MySQL?

I've been using MariaDB, "an enhanced, drop-in replacement for MySQL" on my Debian stable servers for years, because of its increased performance. However I've noticed that it appears to lag with relation to security updates in MySQL; for instance,…
artfulrobot
  • 3,401
19
votes
5 answers

How to view mariadb log?

I am using new relic to monitor the performance of my server. Recently I noticed a very strange problem where for every 3 hours, the server will be down for 1 minute. And in the new relic report, during the server down time, there were sudden spike…
dev-jim
  • 323
18
votes
1 answer

mariadb.service start stuck at activating

I just installed the mariadb in my ubuntu 19.10 by sudo apt install mariadb-server mariadb-client after when I am trying to start the server by sudo systemctl start mariadb.service shell get freeze I have to use Ctl+c to get shell running. In the…
Sarthak Kumar
  • 283
15
votes
8 answers

Where is systemd script for mysql.service located?

I am actually using MariaDB (drop-in replacement for MySQL). I'm trying to make some changes to my systemd mysql.service file. I can see it exists because running sudo systemctl lists it and indicates that it is loaded / active / running. The issue…
David Mackey
  • 752
15
votes
1 answer

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new system (Manjaro/Arch) with MariaDB. $ mysql…
donquixote
  • 521
11
votes
3 answers

How to uninstall MariaDB and re-install MySQL? MySQL install turns into MariaDB install

I recently upgraded my CentOS system via the desktop. Mistake! I had MariaDB, phpMyAdmin working just fine before - but after the upgrade they stopped. I frantically googled and tried to follow some tutorials about MariaDB MySQL reinstall until I…
Suma
  • 111
11
votes
1 answer

MariaDB vs Percona server - main differences?

I'm running Mysql in production today but are planning to switch to either MariaDB or Percona server when I move to new servers. The main reason for the switch is to distance us from Oracle, but also to get better performance and new features. It…
Chrille
  • 483
11
votes
2 answers

Why does adding one character to my MySQL password lock me out?

I am able to log in via mysql -u myuser -p mydb -h localhost with this: grant all privileges on mydb.* to myuser@'%' identified by '1234567890123456789012345678901234567890123456789012345678901234567890123456789'; But not after I do this: grant…
Isaac
  • 221
  • 2
  • 6
10
votes
4 answers

Has anyone migrated production machines from MySQL to MariaDB?

I'm running MySQL for most of our DBs right now, and would like to get off the Oracle ship before it takes more of a turn. My understanding is that the transition from MySQL->MariaDB should be trivial, but going the other way is not so easy. Has…
Bryan Agee
  • 1,229
9
votes
2 answers

mariadb mad file take all space in hard drive

My disk is full, an .MAD file in tmpdir takes up all the space on the file system (50G out of 110G) from log: [Warning] mysqld: Disk is full writing '/var/tmp/#sql_b6f_0.MAD' (Errcode: 28). Waiting for someone to free space I execute the service…
Guillermo
  • 93
9
votes
3 answers

MariaDB MySQL shows have_ssl disabled when certs are installled

Trying to enabled SSL on my mariadb-server. I have followed the official mariadb docs to generate a ca-key ca-cert server-key server-cert. My machine is a debian 9 kvm vps with mariadb 10.1.37 When I run SHOW VARIABLES LIKE '%ssl'; as root I get…
Reece
  • 241
9
votes
1 answer

Digital Ocean CentOS7 server, unable to --skip-grant-tables or restart mysql

I set up a Digital Ocean droplet (server) a few days ago and need to access mysql. No password for root is working amongst what I've tried. However this command: service mysql[d] stop Doesn't work. Apparently I am supposed to issue this…
Oliver Williams
  • 296
  • 1
  • 3
  • 13
1
2 3
…
61 62