I’ve read up on Percona a fair bit, and would like to upgrade my server to run on the latest stable 5.5 release.
I’m still on Mysql 5.0.77 though. CentOS 5.6.
I went to http://www.percona.com/docs/wiki/percona-server:start#instal lation_instructions to read what I need to do, but unless I’m being blind there’s no information there? The “migrating from” text has no link to follow?
My website is popular, but a few hours downtime isn’t the end of the world. I don’t have any other boxes that I can test on, and don’t really want to go to the trouble of creating a VM. I’m happy just to backup and do it live on the production box, knowing I can undo it all and revert back to MySQL 5.0 if need be.
I feel all of my database usage is pretty standard - I doubt there will be any compatibility issues with my SQL as it’s just run-of-the-mill select/update/deletes etc. I’ll obviously test it thoroughly once I’m up and running though.
So, any pointers? I feel I should just do a sql dump, uninstall mysql, install percona, and load the db back in from that batch file? Is this a terrible idea? Educate me!