How to Upgrade MySQL 5.1 to MariaDB 10.0 on CentOS 6 Print

  • 105

Step #1: Upgrade from MySQL 5.1 to MariaDB 5.5

The proper upgrade path from MySQL 5.1 to MariaDB 10.0 is as follows:

1. MySQL 5.1

2. MariaDB 5.5

3. MariaDB 10.0

Step #2: 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

Then disable the MariaDB 5.5 repo:

mv /etc/yum.repos.d/MariaDB55.repo /etc/yum.repos.d/MariaDB55.repo.disabled

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

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

# MariaDB 10.0 CentOS repository list – created 2014-10-10 17:33 UTC
name = MariaDB
baseurl =

Then exit and save the file with the command :wq .

Step #3: Add the EPEL Repository

MariaDB may have dependencies such as socat that are apart of Extra Packages for Enterprise Linux (EPEL), which is a community repository of non-standard packages for the RHEL distribution. To install the EPEL repository:

rpm -iUvh

Step #4: Remove the Existing MariaDB Installation

Be sure to backup MySQL before proceeding with the following instructions!

Stop MariaDB:

service mysql stop

Remove the existing MariaDB packages:

yum -y remove mysql-server mysql-client

Clean-up the repository cache information with the following command:

yum clean all

Step #5: Install MariaDB 10.0

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

yum -y install MariaDB-server MariaDB-client

And then start MariaDB again:

service mysql start

Be sure that MariaDB is set to start at boot:

chkconfig mysql on

Run mysql_upgrade:


Verify MySQL is now MariaDB by using the command client:


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

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

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

MariaDB [(none)]>

Was this answer helpful?

« Back