Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

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

FISHFISH EntrantCurrent User Role Beginner
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.

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi Fish;

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

    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
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.