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,364
    Likes Received:
    50
    Trophy Points:
    28
    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:
    36,509
    Likes Received:
    1,219
    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:
    36,509
    Likes Received:
    1,219
    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. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

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

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    351
    anseme
    Jan 7, 2017
  3. luigidelgado

    Replication after upgrading MySQL 5.6 to MariaDB

    luigidelgado, Mar 7, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    604
    cPanelMichael
    Mar 8, 2016
  4. cristis

    Error upgrading MySQL 5.6 to MariaDB 10.1

    cristis, Jan 31, 2016, in forum: Database Discussions
    Replies:
    6
    Views:
    1,395
    cPanelMichael
    Feb 6, 2017
  5. IRZQ88

    Out of RAM after upgrading to Easyapache4

    IRZQ88, May 5, 2017, in forum: EasyApache
    Replies:
    1
    Views:
    188
    Infopro
    May 5, 2017

Share This Page