MySQL distribution change e.g. MySQL community edition to Percona Server

MySQL & MariaDB Other MySQL® Questions
1

Hi,
I would like to know process/steps to change following
5.1.34sp1-enterprise-gpl-advanced-log MySQL Enterprise Server - Advanced Edition (GPL)
to Percona Server 5.1.X ( 5.1 latest release)

Are these different MySQL distributions compatible with each other ( I understand that some version might have some extra features/performance etc) ? What is process to convert above to Percona release or Percona release to Community Release etc ?

Thanks a lot.

2

Hi sanjay92;

Oracle MySQL and Percona Server are binary compatible, meaning Percona Server is a direct drop-in replacement for Oracle MySQL (Community or Enterprise). Percona Server does have a few features that once enabled make it hard/impossible to go back to Oracle MySQL, but those must be explicitly enabled and are not often used. In the case of going from Oracle’s Enterprise MySQL Server 5.1.x to Percona Server 5.1.x, you should have no issues, but it is still always a good idea to test it first on a development/test instance to make sure there are no surprises. You basically stop MySQL, remove the Oracle MySQL binaries, install the Percona Server binaries, start MySQL, and then run mysql_upgrade (though in your case mysql_upgrade likely won’t do anything, but it’s a good practice to run it regardless). And again, I recommend testing this on a development environment first to be safe.

-Scott

3

Thanks Scott.