Hi guys.

I just saw a mysql update to 5.5.16-2.el5.art from version 5.1.59-1.el5.art on the ASL repo.

Has anyone tried it on plesk 10.3? Are there any known issues ?
Does anyone know the reasons of this update ?
Also should we after this upgrade run a mysql_upgrade ?

Thanks !

I'm to scary to do this update with so many hosting clients on the servers.
Everytime i do mysql update it will be down so i'll wait.

I applied the update on a 1 domain box. With 2 databases and it worked. Just to be sure I run a mysql upgrade for all dbs.

Not applying it still on Plesk server. I'll wait to see how it goes.

Ok got an error...


First of all when mysql-server was installing it posted out on both boxes :




But on one box it printed out 2 errors.

and that it cannot find root@localhost password. But plesk only has admin password. On the other plesk box I did not see these 2 errors.


Everything though seems to be working fine up to now. But I know errors do not usually turn out good...

I did a yum reinstall of mysql-server on the box with the 2 errors. It reprinted




Any suggestions ?

Thanks !

i got a dependency error with centos 6 cr.

Error: Package: mysql-test-5.5.16-2.el6.art.x86_64 (atomic)
Requires: perl(lib::v1/mtr_timer.pl)
Requires: perl(lib::v1/mtr_misc.pl)
Requires: perl(lib::v1/mtr_stress.pl)
Requires: perl(lib::v1/mtr_gprof.pl)
Requires: perl(lib::v1/mtr_im.pl)
Requires: perl(lib::v1/mtr_process.pl)
Requires: perl(lib::v1/mtr_cases.pl)
Requires: perl(lib::v1/mtr_unique.pl)
Requires: perl(lib::v1/mtr_report.pl)
Requires: perl(lib::v1/mtr_gcov.pl)
Requires: perl(lib::v1/mtr_match.pl)
Requires: perl(lib::v1/mtr_io.pl)

Now that 5.5.17-1 is out do we need to go to 5.5.16-2 first to utilise its upgrade to the db format? I tried 5.5.16-2 but encountered issues so tolled back to 5.1

No it has the same update function in it, you'd just upgrade directly to 5.5.17

Updated from 5.1.59 to 5.5.17 on Plesk 9.3; all went perfectly...
Ran mysql_upgrade -u admin -p for good measure, but it reported all ok...
Hope this helps,
Be Well,
Peter

Do we need to remove php-mysql after the 5.5 upgrade?
Because I'm getting:

[root@panel log] # yum reinstall php-mysql
Loaded plugins: allowdowngrade, fastestmirror, priorities
Setting up Reinstall Process
Loading mirror speeds from cached hostfile
* atomic: www6.atomicorp.com
* base: mirror.highspeedweb.net
* centosplus: mirror.us.leaseweb.net
* extras: mirror.anl.gov
* updates: mirrors.login.com
Excluding Packages in global exclude list
Finished
40 packages excluded due to repository priority protections
Installed package php-mysql-5.2.17-1.el5.art.i386 not available.
Nothing to do
[root@panel log] # yum update php-mysql
Loaded plugins: allowdowngrade, fastestmirror, priorities
Loading mirror speeds from cached hostfile
* atomic: www6.atomicorp.com
* base: mirror.highspeedweb.net
* centosplus: mirror.us.leaseweb.net
* extras: mirror.anl.gov
* updates: mirrors.login.com
Excluding Packages in global exclude list
Finished
40 packages excluded due to repository priority protections
Setting up Update Process
No Packages marked for Update
[root@panel log] #