Upgrading MySQL 5.6 to higher versions when GTID replication is enabled

mail2virtusolabsmail2virtusolabs EntrantActive Member Participant
Hi,
I need your help on proceeding MySQL upgrade when GTID is enabled on Oracle Enterprise MySQL servers, Below are the couple of details
1. topology one master having 3 slaves
2. Current Version : 5.6
3. Consideration: upgrading it to 5.7 and 5.7 to higher in future
Send your thoughts on do's and dont's (limitations) along with references if any.

Comments

  • jriverajrivera Percona Support Engineer Percona
    Always begin the upgrade on the slaves, promote one of the upgraded slaves and upgrade the old master and configure it as slave of new master. Make sure to not forget to execute mysql_upgrade when upgrading from one major version to another.
  • mail2virtusolabsmail2virtusolabs Entrant Active Member Participant
    Thanks for the reply. and do we need any special considerations to handle GTID during this process
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.