How to replace MySQL with MariaDB

Thinking about moving from MySQL to MariaDB? Then you must read this post!

"Below you will find some steps on how to affectively stop cPanel/WHM from maintaining MySQL and begin utilizing MariaDB for any and all database activity on your server. MariaDB is “An enhanced, drop-in replacement for MySQL” (Source: https://mariadb.com/). The guide found below is based around utilizing the new RPM tools we provide in 11.36. 

Important Links
MariaDB Versus MySQL Compatibility
MariaDB Versus MySQL Features

Documentation on the RPM system provided by cPanel & WHM

Step 1: Backup existing MySQL data

Make sure to save all existing data just in case there are any issues.

cp -Rf /var/lib/mysql /var/lib/mysql-old
mv /etc/my.cnf /etc/my.cnf-old"

READ MORE AT THE ORIGINAL POST: http://blog.cpanel.net/mysql-mariadb/

Check out my new book on MySQL 5.6 http://www.amazon.com/dp/B00KSMWLH0