How to Replace MySQL with MariaDB

Simple Steps Migration From MySQL To MariaDB On Linux

Step #1 : Add the MariaDB Repository

#yum -y update
# vim /etc/yum.repos.d/MariaDB55.repo

Insert below code in that file:
# MariaDB 5.5 CentOS repository list – created 2014-10-03 15:57 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://server1.kproxy.com/servlet/redirect.srv/slxv/sknlueob/sdmr/p1/5.5/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Then exit and save the file with the command :wq .

Note: Take the Backup all the Databases for Feature Reference

Step #2: Remove the Existing MySQL Installation

# service mysqld stop
# yum -y remove mysql-server mysql


Step #3: Install MariaDB

# yum -y install mysql-server mysql
# service mysql start
# mysql_upgrade
# mysql

You will see below message:
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.

MariaDB [(none)]>