gowrann

Member
Oct 23, 2011
15
0
51
cPanel Access Level
Website Owner
Hi All,

With MySQL being end of life at the end of the year, the time is approaching to upgrade to version 5.5.

2 questions;
a) Is it generally safe to upgrade using the WHM tool, with sites generally comprising of regular CMS systems WordPress, Drupal...

b) Is MySQL server unavailable during the upgrade process?

Many Thanks
 

24x7server

Well-Known Member
Apr 17, 2013
1,911
96
78
India
cPanel Access Level
Root Administrator
Twitter
Hello,

Yes, You can upgrade your MySQL using WebHost Manager (WHM) via the following menu path:
WHM: Main >> Software >> MySQL Upgrade

And here are the MySQL upgrade Docs : MySQL Upgrade
 

gowrann

Member
Oct 23, 2011
15
0
51
cPanel Access Level
Website Owner
Hi - yes understand where it is and how to use it - was looking for feedback from people that have upgraded - good/bad?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello :)

MySQL upgrades are generally safe, however there can be compatibility issues with your older applications if they do not support the use of MySQL 5.5. It's often a good idea to check the versions of the applications installed on your websites and verify they are compatible with MySQL 5.5.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Yes, there will be a period of time when the new MySQL RPMs are installing that MySQL will not be accessible. If the MySQL version is changing, there may also be a period of time where your PHP scripts that use MySQL may not load while EasyApache builds PHP against the new version.

Thank you.
 

gowrann

Member
Oct 23, 2011
15
0
51
cPanel Access Level
Website Owner
Ok did the upgrade which went well - there is downtime for all sites during the upgrade with an error 500 displayed if browsed to.

I had the unattended mysql upgrade and the lower version of PHP was compiled afterwards, so had to run easyapache after to get to the latest php (maybe I hadn't saved my prior config), the downtime was about 20 minutes - that was for me and I had about 500mb of compressed mysql data for about 100 sites.

But yes upgrade was ok!