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 MySQL from 5.0 to 5.1 or 5.5

Discussion in 'Database Discussions' started by sparek-3, Jul 25, 2013.

  1. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,384
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What version of MySQL are most people running these days? I am using mostly cPanel 11.36, if that makes any difference. Are most people using MySQL 5.1 or MySQL 5.5?

    Most of my servers appear to be running MySQL 5.1, but I understand that this is going end-of-life at the end of the year.

    The paramount issue right now, is that I have a handful of servers that are using MySQL 5.0, which I gathered went end-of-life at the end of 2011. I'm assuming that those servers need to be upgraded first. Should I upgrade those to MySQL 5.1 or skip ahead to MySQL 5.5?

    Are there any "gotchas" involved in upgrading from MySQL 5.0 to one of the newer versions? I recall there being a lot of problems previously with an upgrade from MySQL 4.0 to MySQL 4.1 (I think that was the upgrade, I don't remember all of the specifics. If I recall correctly it had to do with one of the table storage engines being deprecated in the MySQL 4.1 upgrade).

    Is the upgrade from MySQL 5.0 to MySQL 5.1 fairly seamless?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The best way to upgrade MySQL is through Web Host Manager:

    "WHM Home » Software » MySQL Upgrade"

    It takes you through each step and lists potential warnings for the upgrade. If you are going through the effort of upgrading MySQL, my personal advice is to upgrade to MySQL 5.5 and deal with any compatibility issues. This way you do not have to do the same thing again when you go from 5.1 to 5.5 when 5.1 becomes end-of-life on December 31, 2013.

    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. Please note that downgrades to previous versions of MySQL are unsupported. Once your system has been upgraded to a newer version of MySQL it may be impossible to switch back.

    Thank you.
     
  3. xer

    xer Registered

    Joined:
    Jul 18, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hello,
    During the upgrading to 5.5, if the server will be off line or something? if it has a risk of data loss?
    Our MySQL version is 5.1.72.
    The "End of Life Date" of MySQL 5.1 is December 31, 2013, does it means, after that day, mysql 5.1 will work?
     
  4. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    867
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    1) The server will remain online during the upgrade though you should backup your entire Mysql database as a precaution.
    2) At the stroke of midnight on December 31 Mysql 5.1 will self destruct :eek:
    .................... Just joking. Mysql 5.1 will continue to work but there will not be any updates or bug fixes made available so you should upgrade.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The MySQL service itself may be unavailable for a short time period during the actual update. However, updates don't typically take more than a few minutes. MySQL 5.1 will still function after the EOL date, but it becomes unsupported and no future updates for it are released.

    Thank you.
     
Loading...

Share This Page