Upgrading MySQL from 5.0 to 5.1 or 5.5

[sparek-3]

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?

 

[cPanelMichael]

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.

 

[xer]

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?

 

[kernow]

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
.................... 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.

 

[cPanelMichael]

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?

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.