MySQL 5.5 released

breun · **Posted:** Thu Dec 16, 2010 9:50 am

http://www.oracle.com/us/corporate/press/195726

BruceLee · **Posted:** Thu Dec 16, 2010 9:52 am

wow, from 5.1 to 5.5. Must be tons of changes

breun · **Posted:** Thu Dec 16, 2010 10:06 am

The change from Sun to Oracle alone probably warranted at least a .4 upgrade according to management.

Highland · **Joined:** Mon Apr 10, 2006 12:55 pm **Posts:** 656

Given the MySQL 5.1 launch, this should be stable enough for production by Q1 2012

A more detailed list of changes
http://dev.mysql.com/doc/refman/5.5/en/ ... shell.html

Highland · **Joined:** Mon Apr 10, 2006 12:55 pm **Posts:** 656

Yes, I have been singing the praises of Drizzle but we recently moved to Amazon RDS (team decision), which supports MySQL 5.5. Several other repos now have 5.5. Is there any chance this could make its way into bleeding or testing soon?

NOTE: The client for 5.5 is incompatible with 5.5.10 and earlier

scott · **Posted:** Thu Jul 07, 2011 6:53 pm

Hmm so question there, if you build php against mysql 5.5 would that php app still be able to connect to a 5.1 server?

Highland · **Joined:** Mon Apr 10, 2006 12:55 pm **Posts:** 656

Here's the bug that prompted the change (should have linked it). I might have misunderstood but another repo I am using for 5.5 right now noted it.

Quote:

Incompatible Change: The shared library version of the client library was increased to 18 to reflect ABI changes, and avoid compatibility problems with the client library in MySQL 5.1. Note that this is an incompatible change between 5.5.10 and earlier 5.5 versions, so client programs that use the 5.5 client library should be recompiled against the 5.5.10 client library. (Bug #60061, Bug #11827366)

http://bugs.mysql.com/bug.php?id=60061
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-10.html

scott · **Posted:** Mon Jul 11, 2011 3:36 pm

Ok on closer examination that doesn't seem to be a big deal, they were just overlapping names with the 5.1 library series. So it should be (at least from what I'm reading) be OK to link PHP 5.3 against the mysql 5.5 library, and it will work against a mysql 5.1 server.

So next question, who out there is running it and what kinds of problems did you run in to? Did you have to run mysql_upgrade? Do any applications (plesk?) have problems with it?

Highland · **Joined:** Mon Apr 10, 2006 12:55 pm **Posts:** 656

Good to hear. I was hoping I misunderstood it because it didn't sound like fun to try and work around.

I don't think you can upgrade a major or minor version without mysql_upgrade. It's not terribly common, however, so not a huge deal.
So far I've had no problems running on 5.5 in production. Required nothing special as far as SQL went that I've seen. I don't run Plesk with it, however.

scott · **Posted:** Tue Jul 12, 2011 2:51 pm

That'd be another key question, what versions of plesk will it work with. If anyone else is running 5.5 with plesk or found a conflict with anything else this is a good time to bring it up

breun · **Posted:** Wed Jul 13, 2011 6:38 am

The Plesk 10.3.0 release notes mention MySQL 5.5 under 'Third-party components upgrades': http://download1.parallels.com/Plesk/PP ... ed-os.html

I don't know if this means that 10.3 is the first version of Plesk which is compatible with MySQL 5.5 or if older versions (9.x?) also work with MySQL 5.5.

Highland · **Joined:** Mon Apr 10, 2006 12:55 pm **Posts:** 656

I got a chuckle out of this. I installed the 5.5 in testing and this notice popped up

Quote:

WARNING : This MySQL RPM is not an official Fedora/Redhat build and it
overrides the official one. Don't file bugs on Fedora Project nor Redhat.
Use dedicated forums http://forums.famillecollet.com/

I had to double check that I hadn't installed the remi repo there by mistake, but, nope

Quote:

Dependency Installed:
mysqlclient16.x86_64 0:5.1.57-1.el5.art

Updated:
mysql.x86_64 0:5.5.14-1.el5.art mysql-libs.i386 0:5.5.14-1.el5.art
mysql-libs.x86_64 0:5.5.14-1.el5.art mysql-server.i386 0:5.5.14-1.el5.art
mysql-server.x86_64 0:5.5.14-1.el5.art

Oops?

RS_Jelle · **Joined:** Sat Dec 09, 2006 7:05 am **Posts:** 20

breun wrote:

The Plesk 10.3.0 release notes mention MySQL 5.5 under 'Third-party components upgrades': http://download1.parallels.com/Plesk/PP ... ed-os.html

I don't know if this means that 10.3 is the first version of Plesk which is compatible with MySQL 5.5 or if older versions (9.x?) also work with MySQL 5.5.

No, it should work fine with 10.2 too. In that version they fixed a 5.5 compatibility bug:

Quote:

61. [-] Issue resolved: If MySQL 5.5 was installed on the server, Panel installation or upgrade failed because Panel tried to use a deprecated option to configure it.

http://download1.parallels.com/Plesk/PP ... htm#10.2.0

The thing in the 10.3 release notes means that Parallels distributes a MySQL 5.5 package for CentOS with Plesk 10.3, they said.
http://forum.parallels.com/showthread.p ... post448674

scott · **Posted:** Wed Jul 13, 2011 4:08 pm

I couldnt find the plesk 5.5 package so I started testing with remi's. So far I havent run into anything other than the standard mysql_upgrade requirements (needed after 5.1 I found).

Did I miss something obvious with plesk 10.3 on where to get the 5.5 packages?

MySQL 5.5 released

Who is online