[atomic] Mysql 5.1 for Plesk

[atomicturtle]

The Atomic repo has now standardized on mysql 5.1; Current release is 5.1.48

The upgrade procedure is documented here:
http://www.atomicorp.com/wiki/index.php/Mysql


Please note that if you are upgrading from mysql 4, 4.1, or 5.0 to 5.1 you will need to make some additional changes to your configuration that are documented in the url above.

 

[thewolf]

If one wants to stay with MySQL 5.0 for some time, how do you do that still using the Atomic repo?

Thanks.

 

[atomicturtle]

The package is still available in the repo, you can try specifying the exact version when you invoke yum. I dont know how much longer it will stick around in the repo though.

 

[thewolf]

Thanks, it would be great if you could keep the MySQL 5.0 packages in the repo for a few months, I think other users may need them too.

 

[atomicturtle]

Sure they'll stick around for another month or two

 

[shall]

I installed MySQL thru Atomic, and `mysql --version` now returns:

mysql  Ver 14.14 Distrib 5.1.48, for redhat-linux-gnu (i686) using readline 5.1

Plesk (9.5.2) reports 'mysql 5.1.48-1.el4.art' within the 'Server Components' page.

However, phpinfo() still returns:

mysql
MySQL Support enabled 
Active Persistent Links  0  
Active Links  0  
Client API version  4.1.22  
MYSQL_MODULE_TYPE  external  
MYSQL_SOCKET  /var/lib/mysql/mysql.sock  
MYSQL_INCLUDE  -I/usr/include/mysql  
MYSQL_LIBS  -L/usr/lib/mysql -lmysqlclient

MySQL as returned by mysql_get_server_info() returns the correct version.

What do I need to do to ensure that this is all operating correctly? I'm afraid that the client API might cause problems.

If it matters, I'm running RHEL4.

 

[atomicturtle]

That is a feature, as mentioned on the PHP page here:
http://www.atomicorp.com/wiki/index.php/PHP

"Linked against the native OS database libraries (mysql4 for RHEL/CentOS4 for example)"

 

[Dan Mikkelsen]

Are these for CentOs only, or would it be possible to use this on Debian Lenny also?

 

[danliker]

for debian you can use dotdeb.org

 

[Dan Mikkelsen]

Ok thanks!

Have you all had succes with the update to 5.1, without PLESK breaking down or something?

 

[atomicturtle]

Latest release is now 5.1.51, available for centos 4/5, rhel 4/5, and fedora 6-13

 

[lvalics]

On a few server I have updated, where I know that is no unicode characters, that was in the past an issue. Where I have updated, all is OK. Now I prepapre the rest of the server to upgrade, hope all will be OK.