Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Upgrading to MySQL 5.5

Discussion in 'Database Discussions' started by gowrann, Jun 26, 2013.

  1. gowrann

    gowrann Member

    Joined:
    Oct 23, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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
     
    #1 gowrann, Jun 26, 2013
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,732
    Likes Received:
    78
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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
     
    #2 24x7server, Jun 29, 2013
  3. gowrann

    gowrann Member

    Joined:
    Oct 23, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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?
     
    #3 gowrann, Jun 30, 2013
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,710
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #4 cPanelMichael, Jul 1, 2013
  5. gowrann

    gowrann Member

    Joined:
    Oct 23, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Thanks Michael for that.

    Can you advise on the 2nd part of the question :
    Regards
     
    #5 gowrann, Jul 3, 2013
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,763
    Likes Received:
    1,710
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #6 cPanelMichael, Jul 3, 2013
  7. gowrann

    gowrann Member

    Joined:
    Oct 23, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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!
     
    #7 gowrann, Jul 13, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - Upgrading MySQL
  1. Sayem

    Activate MySQL 5.7 after upgrading to v70.0.12

    Sayem, Feb 16, 2018, in forum: Database Discussions
    Replies:
    1
    Views:
    253
    cPanelMichael
    Feb 19, 2018
  2. Venomous21

    Upgrading to MySQL 5.7

    Venomous21, Jan 30, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    704
    cPanelMichael
    Jan 31, 2018
  3. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    891
    rpvw
    May 16, 2017
  4. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    761
    anseme
    Jan 7, 2017
  5. ciao70

    SOLVED Upgrading to Apache 2.4.33?

    ciao70, Mar 26, 2018, in forum: EasyApache
    Replies:
    10
    Views:
    357
    cPStacy
    Apr 4, 2018

Share This Page