Ubuntu 12.04 - Replacing MySQL 5.5 with latest Percona server

MySQL & MariaDB Other MySQL® Questions
1

We have a large MySQL server with Innnodb and some MyISAM.
What is the easiest way of replacing the stock MySQL with Peronca.

From what I understand, I uneed to remove MySQL server (how about the client) through apt-remove ?
Or do I just install percona-server through APT and it will automatically remove and install the proper packages?
how about the command line client? (mysql-client)

tia

2

If you are upgrading from a similar version (i.e. MySQL 5.5.27 to Percona 5.5.27) then the process is fairly straight forward; just remove the old binaries and install the new binaries.

If you will be also upgrading the version, then you’ll want to replace the binaries and follow the usual MySQL upgrade process:

[URL]http://dev.mysql.com/doc/refman/5.5/en/upgrading.html[/URL]

3

just to update this thread.
On Ubuntu 12.04 the following packages need to be uninstalled;
mysql-client mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5

an easy way of replacing the standard MySQL 5.5 with Percona Mysql 5.5 is:
Configure the Apt repository:
http://www.percona.com/doc/percona-server/5.5/installation/a pt_repo.html

$sudo service mysql stop ← make sure MySQL is fully stopped. For some reason the uninstall process (below) will not stop MySQL and there will be LOCK issues with the datadir when Percona Server starts.

$sudo apt-get install percona-server-server-5.5 percona-server-client-5.5

It will run uninstall the needed packages and replace them with Percona:

The following packages were automatically installed and are no longer required:
linux-headers-3.2.0-23-generic linux-headers-3.2.0-23
Use ‘apt-get autoremove’ to remove them.
The following extra packages will be installed:
percona-server-common-5.5
Suggested packages:
tinyca
The following packages will be REMOVED:
mysql-client mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
The following NEW packages will be installed:
percona-server-client-5.5 percona-server-common-5.5 percona-server-server-5.5
0 upgraded, 3 newly installed, 7 to remove and 3 not upgraded.

I hope I’m not missing anything.

4

tomsk,

Yes that’s correct, you have to replace the mysql client and shared libraries like mysql-common too.

Martin

@martinarrietac