How to install MariaDB in cPanel

install mariadb cpanel

MariaDB Server – the world’s fastest growing open source database. It’s used by companies in mission-critical environments whilst ensuring optimum availability and performance. cPanel team doesn’t support MariaDB as of now but we can replace MySQL with MariaDB.

Stop and disable the MySQL service

/etc/init.d/mysql stop

WHM >> Service Manager >> Uncheck MySQL >> Save

Make copy of existing MySQL data in case something goes wrong

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

Disable the targets so cPanel no longer handles MySQL updates

/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

Uninstall MySQL

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

Install MariaDB

Create file /etc/yum.repo.d/mariadb.repo and add below lines if your server is CentOS 6 64bit.

# MariaDB 5.5 CentOS repository list - created 2014-01-05 00:39 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

For different OS get the repo lines from https://downloads.mariadb.org/mariadb/repositories/
Now install the MariaDB

yum install MariaDB-server MariaDB-client MariaDB-devel

Restart and update MariaDB

/etc/init.d/mysql start
 mysql_upgrade
 /etc/init.d/mysql restart

Rebuild easyapache/php to ensure modules are intact/working

/scripts/easyapache --build

Please check out our 24×7 cPanel Server Management Service plan if you want professional system administrator to do these tasks for you.

About 

Sreejit is the founder of Server Management Plus. His motto is "If there's an easier way, Why do it any other way" and following it, he has created a lots of automation scripts for the company using which we are able to resolve issue at an extremely fast rate and save lots of time. He has a very keen interest in new technologies and spend most of his free time online researching about it apart from listening music and watching movies.