0

I'm wanting to drop in Percona instead of MySQL (5.1) on my Natty ubuntu server. I've added the keys and the repos.

I've added a natty repo, even though it's not supposed to exist and it seems to be fine. The problem is when I go an apt-get install percona-server-server, it tells me that it depends on percona-server-server-5.5 and won't be installed.

Should I just install 5.5 (over the top of mysql 5.1) or do I need to install percona 5.1? Or do I need to pick a different repo and let it decide?

thefella
  • 1
  • 2

1 Answers1

0

Fist, please note that the Percona Server natty repository is probably not going to receive updates any more, as Ubuntu will make natty unsupported very soon. If you check the available packages, you will see that the lastest stable version for natty is "5.5.23-rel25.3-240" while the lastest version for lucid or precise is "5.5.27-rel28.1-296", with some important security updates. I would advice you to choose a recent LTS version to avoid some nasty bugs in earlier versions of MySQL.

percona-server-server is a metapackage that depends on the latest PS version. You can choose to install either percona-server-server-5.1 or percona-server-server-5.5. Please be aware that Percona conflicts with MySQL official package, so it will uninstall it. Check the validity of the repositories. As an alternative, you can download manually both the .debs and .bin of the PS server and client.

PS 5.5 should work better than 5.1, but you should test any software upgrade beforehand, as it may break your particular application (no matter if you change to a new major version of Percona, Oracle's MySQL or MariaDB). Running mysql_upgrade after install should resolve most incompatibilities at server level, but you should read carefully the release notes for the particular version to see any 5.1 -> 5.5 changes. Please note that replacing the exact same versions of MySQL and PS should be safe with the default configuration. There are no changes on the client software.