MySQL 5.5 released

[breun]

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

[BruceLee]

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

[breun]

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

[Highland]

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]

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]

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]

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.

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]

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]

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]

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]

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]

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

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

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]

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:

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]

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?