Buy Percona ServicesBuy Now!

Upgrading MySQL 5.6 to higher versions when GTID replication is enabled

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Upgrading MySQL 5.6 to higher versions when GTID replication is enabled

    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.
    Last edited by mail2virtusolabs; 10-07-2016, 09:31 AM.

  • #2
    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.

    Comment


    • #3
      Thanks for the reply. and do we need any special considerations to handle GTID during this process

      Comment

      Working...
      X