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!

Upgrading to MySQL 5.5

Discussion in 'Database Discussion' 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,789
    Likes Received:
    83
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    43,704
    Likes Received:
    1,791
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    43,704
    Likes Received:
    1,791
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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. keat63

    Upgrading MySQL 5.6 to MariaDB 10.2 Question

    keat63, May 17, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    185
    cPanelMichael
    May 18, 2018
  2. Sayem

    Activate MySQL 5.7 after upgrading to v70.0.12

    Sayem, Feb 16, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    486
    cPanelMichael
    Feb 19, 2018
  3. Venomous21

    Upgrading to MySQL 5.7

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

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    967
    rpvw
    May 16, 2017
  5. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    815
    anseme
    Jan 7, 2017

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice