Thursday, May 23, 2013

How To Upgrade The Mysql To Percona on WHM/cPanel Server.!

Imp: Please take backup of database and mysql config file my.cnf

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

Check the Mysql version:

mysql -V
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64)

We need to Disable the Mysql in cPanel:

/scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled

The following script will remove the mysql from your server.

/scripts/check_cpanel_rpms --fix --targets=MySQL51


Then, Download the Percoana repository and install it on server:

rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Preparing...                ########################################### [100%]
   1:percona-release        ########################################### [100%]

After that you can install the Percona server and req. pacakges.

 yum install Percona-Server-client-55 Percona-Server-server-55 Percona-Server-devel-55 Percona-Server-shared-55 Percona-Server-55-debuginfo.x86_64   Percona-Server-test-55.x86_64

Start the Percona Mysql:
/etc/init.d/mysql start

Upgrade your data with Percona: It will shows you "OK" if its done successfully.
mysql_upgrade

Then again restart the Mysql:
/etc/init.d/mysql restart

Now, For PHP and Apache you have to rebuild the Apache and PHP using following script:
/scripts/easyapache --build

After completion it will shows you.

!!
!! Build Complete! !!

Good You Done IT..Now you can have well optimized PerconaDB.. and you can Enjoy the performance :)

11 comments:

novisign digital signage said...

Congratulations, your blog is appealing and informative. Going through your Information, I found quite a few new ideas to implement

Renu said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
https://www.emexotechnologies.com/online-courses/devops-training-in-electronic-city/

Unknown said...

Thank you provide valuable information and iam searching same information,and saved my timeDevops training



pinky said...

Great content thanks for sharing this informative blog which provided me technical information keep posting.
DevOps Online Training

DevOps Training in Pune

bhanu sree said...

Good post!!!
Azure online training in ameerpet
Microsoft azure training
Azure devops online
Microsoft Azure DevOps Training
Microsoft Azure DevOps Online Training
Microsoft Azure DevOps training hyderabad
Azure DevOps online training in hyderabad

Anu said...

This is really a very good article.Thanks for taking the time to discuss with us , I feel happy about learning this topic. Keep sharing your information regularly for my future reference.
DevOps Training | Certification in Chennai | DevOps Training | Certification in anna nagar | DevOps Training | Certification in omr | DevOps Training | Certification in porur | DevOps Training | Certification in tambaram | DevOps Training | Certification in velachery



Admin said...

Great one, post admin will keep it up...
5 Instant Approval Site (DoFollow Backlink)

swara misra said...

Here is the site(bcomexamresult.in) where you get all Bcom Exam Results. This site helps to clear your all query.
Sri Dev Suman University B.COM HONOURS 1st Sem Exam Result 2019-2022
BA 3rd year Result 2019-20
Sdsuv University B.COM 3rd/HONOURS Sem Exam Result 2018-2021

swara misra said...

Here is the site(bcomexamresult.in) where you get all Bcom Exam Results. This site helps to clear your all query.
Sri Dev Suman University B.COM HONOURS 1st Sem Exam Result 2019-2022
BA 3rd year Result 2019-20
Sdsuv University B.COM 3rd/HONOURS Sem Exam Result 2018-2021

ramya said...
This comment has been removed by the author.
ramya said...

It was really nice blog with lot of innovative thing inside this, I really enjoyable i would like to thank for sharing this valuable content. I was so glad to see this wonderful blog. keep updating this type of blog.amazon web services aws training in chennai . amazon web services aws training in chennai

microsoft azure training in chennai

workday training in chennai

android-training-in chennai

ios training in chennai