MYSQL TO MARIA DB SWITCH

What is MariaDB ?

MariaDB is a binary drop in replacement of the same MySQL version (for example MySQL 5.1 -> MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are compatible. MySQL 5.5 will be compatible with MariaDB 5.5). What this means is that:

* Data and table definition files (.frm) files are binary compatible.
* All client APIs, protocols and structs are identical.
* All filenames, binaries, paths, ports, sockets, and etc… should be the same.
* All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.
* The mysql-client package also works with MariaDB server.
* The shared client library is binary compatible with MySQL’s client library.

*There are some installation issues with PHP5 that you should be aware of ( REF:https://mariadb.com/kb/en/installation-issues-with-php5 ).

#mysqldump --all-databases --routines --triggers > /home/db_dump/alldb.sql

# service mysql stop

# cp -r /var/lib/mysql/mysql /home/db_dump/

# service mysql start

# /scripts/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled

# /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled

# /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled

Disable the targets so cPanel no longer handles MySQL updates ONLY FOR cPanel 11.36+

# /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55

Above command remove rpms

#nano /etc/yum.repos.d/MariaDB.repo

---------
# MariaDB 5.5 CentOS repository list - created 2013-06-23 21:13 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=

--------

Create yum repo , Edit the mariadb version and os distribution by checking current statistics

 yum install MariaDB-server MariaDB-client MariaDB-devel

# /etc/init.d/mysql start
# mysql_upgrade
# /etc/init.d/mysql restart
# /scripts/easyapache --build