Pre-requisite for upgrading for 5.5.40 to 5.6.21 percona mysql (replication)

MySQL & MariaDB Other MySQL® Questions
1

I need to upgrade the percona mysql 5.5.36-34.2-rel34.2 to 5.6.21.

I would like to know what are the pre-requisite to do that.

And more over, my environment is having 4 servers, and one serve as a master for the 3 slaves.

What is the best practice to make that successfull, as this is critical production server.

2

Hi Fish;

The MySQL docs actually have a great (and lengthy) guide for just this:
[url]http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html[/url]

Big things are just make sure you read through all the incompatible changes so there are no surprises (or less chance of anyway), do a mysqldump for the upgrade instead of just an in-place binary replacement (if it all possible), and in a replication environment do the slaves first and then the master (often people just then promote one of the slaves to be the master, and then either upgrade or just rebuild the old master into another slave). These are just mile-high bullet points, but the docs have all the important details. =)

Good luck!

-Scott