Active support for MySQL 5.0 ends soon

Posted in: Technical Track

According to the official lifecycle calendar at http://www.mysql.com/about/legal/lifecycle/#calendar, active support for MySQL 5.0 (including regular binary updates) will end on December 31st, 2009, which is about 3 weeks away.

Many folks are still using MySQL 5.0.45, as until October that was the package that came with RedHat. That was released in July 2007, over 2 years ago!

Upgrading to MySQL 5.1 is not difficult, though it requires more steps than just upgrading the packages.

There is a list with all the changes made that might affect the upgrade process at http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation/. This includes which variable names have been deprecated and changed, as well as how to upgrade stored procedures, functions, triggers and views so they work properly in MySQL 5.1.

I hope this helps folks out, and please feel free to ask any questions. Pythian is available to assist you in the upgrade process, just contact us if you want to engage our help.

Interested in working with Sheeri? Schedule a tech call.

5 Comments. Leave new

My problem with MySQL 5.1 that in the default ubuntu linux pacakages at least 5.1 does half the speed what 5.0 did with the very same my.cnf. I have no idea, I tried to follow some advices to optimize settings, but no luck. So we will stay at 5.0 …

Reply

I releases of MySQL are getting delayed than the expected dates so the active support may extend…

Reply

Suresh — releases of MySQL are *not* getting delayed. There are releases monthly, just see:

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

and

http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html

So I doubt they will extend the lifecycle.

LGB — Pythian can help with that too — there have been several bugs that have tripped up people. You should submit bugs, or look for them in the MySQL database. One particular one that we’ve seen that makes queries worse is fixed in MySQL 5.1.37, and it’s shown in these bugs:

http://bugs.mysql.com/bug.php?id=39258
http://bugs.mysql.com/bug.php?id=37680
http://bugs.mysql.com/bug.php?id=36259
http://bugs.mysql.com/bug.php?id=45828

We can help you figure out what the problem is, if it’s not the above….that’s exactly what we do for our customers!

Reply

MySQL 5.0.45 being the default for RedHat till October is only true for RedHat Enterprise Linux (RHEL) 5. The current MySQL versions supported (non end of life’ed) RedHat Enterprise Linux are 5.0.77 for RHEL5, 4.1.22 for RHEL4, and 3.2.58 for RHEL3.

Reply
Log Buffer #172: a Carnival of the Vanities for DBAs | The Pythian Blog
December 11, 2009 1:56 pm

[…] Here on the Pythian blog, Sheeri K. Cabral reports that active support for MySQL 5.0 ends soon. […]

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *