How To Install MySQL / MariaDB on Fedora 20

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Pre-Flight Check
  • These instructions are intended for installing MariaDB on a single Fedora 20 node.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.

Install MariaDB

MariaDB is as simple as running just one command:

yum -y install mysql-server mysql

And then start MySQL, now MariaDB:

systemctl start mysqld

Be sure that MySQL/MariaDB starts at boot:

systemctl enable mariadb

To check the status of MySQL/MariaDB:

systemctl status mysqld

To top MySQL/MariaDB:

systemctl stop mysqld

Check the installation with the command client:

mysql

Your MariaDB connection id is 2
Server version: 5.5.39-MariaDB-wsrep MariaDB Server, wsrep_25.10.r4014

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

Be Sociable, Share!
Here's $75, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support.