{"id":1345,"date":"2014-11-14T23:05:29","date_gmt":"2014-11-15T05:05:29","guid":{"rendered":"http:\/\/blog.supportpro.com\/?p=1345"},"modified":"2019-10-30T04:21:55","modified_gmt":"2019-10-30T10:21:55","slug":"mariadb-an-alternate-for-mysql","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/mariadb-an-alternate-for-mysql\/","title":{"rendered":"MariaDB: An Alternate for Mysql"},"content":{"rendered":"

MariaDB<\/strong> is a high performance drop-in replacement for MySQL, developed by some of the original authors of the MySQL project. For years, MySQL has been the dominant open-source database management system (DBMS). Recently, MariaDB, the MySQL fork created by MySQL’s founder, has been making in-roads and websites like Wikipedia the world’s sixth most popular Web site, is shifting over from MySQL to MariaDB.<\/p>\n

Lets check how to replace MYSQL with MARIADB in a cpanel server<\/span><\/strong><\/p>\n

Step 1<\/strong>: Backup existing MySQL data<\/p>\n

Before installing mariadb make sure to take backup of current mysql data<\/p>\n

# service mysql stop<\/em>
\n# cp -r \/var\/lib\/mysql \/var\/lib\/mysql-back<\/em>
\n# service mysql start<\/em><\/p>\n

Step 2<\/strong>: Disable the targets so cPanel no longer handles MySQL updates<\/p>\n

#\/scripts\/update_local_rpm_versions –edit target_settings.MySQL50 uninstalled<\/em>
\n#\/scripts\/update_local_rpm_versions –edit target_settings.MySQL51 uninstalled<\/em>
\n#\/scripts\/update_local_rpm_versions –edit target_settings.MySQL55 uninstalled<\/em><\/p>\n

Step 3<\/strong>: Remove existing MySQL RPM\u2019s so theres a clean slate for MariaDB<\/p>\n

#\/scripts\/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55<\/em><\/p>\n

Step 4<\/strong>: Create a yum repository for MariaDB<\/p>\n

Access https:\/\/downloads.mariadb.org\/mariadb\/repositories and select the DISTRO and place the repo content to \/etc\/yum.repos.d\/MariaDB.repo.
\n#nano \/etc\/yum.repos.d\/MariaDB.repo<\/em><\/p>\n

====================================================
\n# MariaDB 5.5 CentOS repository list – created 2014-09-16 13:35 UTC
\n# http:\/\/mariadb.org\/mariadb\/repositories\/
\n[mariadb]
\nname = MariaDB
\nbaseurl = http:\/\/yum.mariadb.org\/5.5\/centos6-amd64
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1
\n===================================================<\/p>\n

Step 5<\/strong>: Install MariaDB using the following command<\/p>\n

# yum install MariaDB-server MariaDB-client MariaDB-devel<\/em><\/p>\n

note: If you are encountering in any dependency problem, please remove PHP from the \/etc\/yum.conf file and then run above yum command again<\/p>\n

# \/etc\/init.d\/mysql start<\/em>
\n# mysql_upgrade<\/em>
\n# \/etc\/init.d\/mysql restart<\/em><\/p>\n

ADD the php back to the yum conf file.<\/p>\n

Step 6<\/strong>: Rebuild easyapache\/php to ensure modules are working.<\/p>\n

#\/scripts\/easyapache –build<\/p>\n

Need expert assistance?<\/strong><\/p>\n

SupportPRO<\/strong><\/a> has a team of well experienced professionals. We can assist you in shifting over from MySQL to MariaDB in your server. Feel free to contact us if you need assistance.<\/p>\n

If you require help, contact SupportPRO Server Admin<\/a><\/p>\n

\"Server<\/a><\/span>