Percona Installation in Cpanel Servers

Percona Server is an enhanced drop-in replacement for MySQL. Percona Server is a fork of the MySQL relational database management system created by Percona. It aims to retain close compatibility to the official MySQL releases, while focusing on performance and increased visibility into server operations. Percona freely includes a number of scalability, availability, security and backup features only available in MySQL’s commercial Enterprise edition.

The cPanel allows us to replace the MySQL with Percona if needed. Please follow the steps given below:
~~~
1) Run the following commands to back up your existing MySQL data:
#] cp -afv /var/lib/mysql /var/lib/mysql-old
#] mv -v /etc/my.cnf /etc/my.cnf-old
** You can also use the steps in one of my previous post to take Database backups individually in .sql format. Refer the URL :
https://cpanelgeek.wordpress.com/2015/06/26/cpanel-database-only-migration/

2) Run the following commands to disable the MySQL RPM targets. cPanel & WHM will no longer handle MySQL updates, and the rpm.versions system will mark the associated MySQL and MariaDB RPMs as uninstalled.
#]  /usr/local/cpanel/scripts/update_local_rpm_versions –edit target_settings.MySQL50 uninstalled
#]  /usr/local/cpanel/scripts/update_local_rpm_versions –edit target_settings.MySQL51 uninstalled
#]  /usr/local/cpanel/scripts/update_local_rpm_versions –edit target_settings.MySQL55 uninstalled
#]  /usr/local/cpanel/scripts/update_local_rpm_versions –edit target_settings.MySQL56 uninstalled
#]  /usr/local/cpanel/scripts/update_local_rpm_versions –edit target_settings.MariaDB100 uninstalled
#]  /usr/local/cpanel/scripts/update_local_rpm_versions –edit target_settings.MariaDB101 uninstalled

3) Run the following command to remove the existing MySQL RPMs from your server. This leaves a clean slate for the Percona installation.
#] /usr/local/cpanel/scripts/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55,MySQL56,MariaDB100,MariaDB101

4) Run the following command to create a yum repository for Percona:
#] vi /etc/yum.repos.d/Percona.repo
Copy paste the following code lines in it.
[percona]
name = CentOS $releasever – Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
enabled = 1
gpgkey = http://www.percona.com/redir/downloads/percona-release/RPM-GPG-KEY-percona
gpgcheck = 1

5) Use a text editor to open the /etc/yum.conf file and remove php* and mysql* from the exclude line. The exclude line in your /etc/yum.conf file may appear similar to the following example:
exclude=bind-chroot courier* dovecot* exim* filesystem httpd* mod_ssl* mydns* mysql* nsd* php* proftpd* pure-ftpd* ruby* spamassassin* squirrelmail* 

6) Run the following commands to install Percona and restart the appropriate services:
#] yum install Percona-Server-client-55 Percona-Server-server-55 Percona-Server-devel-55
#] /usr/local/cpanel/scripts/restartsrv_mysql
#] mysql_upgrade
#] /usr/local/cpanel/scripts/restartsrv_mysql

7) Run the following command to create a symlink:
#] ln -sv /usr/lib64/libperconaserverclient.so /usr/lib64/libmysqlclient.so

8) Run Easyapache:
#] /usr/local/cpanel/scripts/easyapache –build

9) Once Evrything is done, Run cpanel update to update the PHPMyAdmin to adapt the settings.
#] /scripts/upcp –force

10) You can find the complete Percona Documentation and Installations steps for different Percona source packages  in the link below:
https://www.percona.com/doc/percona-server/5.6/index.html

11) All Done. Enjoy with Percona.

Have a Great Day Friends !!!! 😉 🙂

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s