Upgrading MySQL to 5.1

[JoyceB]

Hello,

I would like to upgrade my MySQL to 5.1 to use the plugin feature. I am using Cent OS 5 and my bundled package version is 5.0.45.
> Is it possible for me to upgrade my MySQL without breaking Plesk? I found a Knowledge Base article for Plesk 7.5. Is it stil valid?
> My hosting support agent informed me that I won't be able to upgrade my Plesk control panel, if I upgrade my OS bundled MySQL. Is it true?
> Will it help, if I upgrade to Plesk 9.5 from 9.2?

Thanks,
Joyce Babu

 

[atomicturtle]

Sure, mysql 5.1 is available from the atomic repo:

1) add the repo
wget -q -O - http://www.atomicorp.com/installers/atomic |sh

2) Upgrade mysql
yum upgrade mysql

 

[lvalics]

Just be careful because could be to not start MYSQL 5.1, you will need to do some changes in my.cnf and also to upgrade databases to never version. (always MySQL from x.0 to x.1 do stupid things and developers, users will suffer)