How To Install MariaDB on CentOS 6

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 CentOS 6 node.
  • I’ll be working from a TD Web Services Core Managed CentOS 6.5 server, and I’ll be logged in as root. 
Step #1: Add the MariaDB Repository

First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new:

yum -y update

Now find which repo you should use with the MariaDB repository generator. We’re going to add the CentOS 6 (64 bit) MariaDB 5.5 repository.

vim /etc/yum.repos.d/mariadb.repo

# MariaDB 5.5 CentOS repository list – created 2014-10-03 15:57 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Then exit and save the file with the command <reference_page_text>:wq .

Step #2: Remove the Existing MySQL Installation
In some cases a manual uninstall of mysql is necessary. Be sure to backup MySQL before proceeding.

Stop MySQL:

service mysqld stop

Remove the existing MySQL packages:

yum remove mysql-server mysql

Step #3: Install MariaDB

At this point, installing MariaDB is as simple as running just one command:

yum -y install MariaDB-server MariaDB-client

And then start MySQL, now MariaDB, again:

service mysql start

Run mysql_upgrade:

mysql_upgrade

Verify MySQL is now MariaDB by using the command client:

mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.39-MariaDB MariaDB Server

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

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

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How To: Back Up MySQL Databases From The Command Line

While automated backups are important, sometimes you just want to take a quick and dirty snapshot...

How to Display (List) All Jobs in Cron / Crontab

View Root’s Cron Jobs crontab -l  View a User’s Cron Jobs crontab -u username -l Example with...

How To: Automate Server Scripts With Cron

Servers can automatically perform tasks that you would otherwise have to perform yourself, such...

How to find sending spam emails and enable mail header in php.ini

- In Linux servers if there are a lot of emails in the queue "over 100" emails. you can check if...

Install memcache

Step 1: Login into your WHM panel and using easyapache enable Memcache Step 2: SSH into...