Not the answer you need?
Register and ask your own question!

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

sanjay92sanjay92 ContributorCurrent User Role Beginner
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.

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    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
  • sanjay92sanjay92 Contributor Current User Role Beginner
    Thanks Scott.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.