I am looking into upgrading from mysql 5.0 to percona 5.5
This will be on a production server but being cloud based I can easily spin up a testbed.
I experimented before installing percona on another machine and failed to even get it running - however its possible I was trying on 11.04 which appears unsupported. The servers are all 8.04.
I understand that the process is to stop mysql, start percona and then run mysql_upgrade.
Is it possible to install percona alongside mysql when installing from the repositories or would this need to be a manual install?
Roughly how long is mysql_upgrade expected to take on a machine with around 8GB in 200 databases?
Does Percona include innodb and extradb or would all innodb tables get upgraded automatically?
Any other concerns or considerations to be aware of?