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

Help with rolling Upgrade

OS_DBAOS_DBA EntrantInactive User Role Beginner
Architecture:
MySQL 5.6.24 two node active-passive cluster managed by Pacemaker (with MySQL replication), with DRDB mirrored file system for the Magento application tier.

What we need to do:
Rolling upgrade to 5.6.29, with no interruption to service and no data loss.

High Level Plan:
  1. Put Pacemaker in maintenance mode
  2. Shutdown the slave database (database B).
  3. Upgrade the MySQL binary packages for database B.
  4. Start database B.
  5. Run the upgrade script
  6. Restart MySQL replication and let the Slave (B) resync with the master (A). Check DRBD is up to date.
  7. Promote B to Master.
  8. Shutdown the old master database (A)
  9. Upgrade the MySQL binary packages for database A
  10. Start database A.
  11. Run the upgrade script
  12. Restart MySQL replication and let it sync with database B. Check DRBD is up to date
  13. Promote A to master
  14. Turn Pacemaker maintenance mode off.
  15. Ensure Slave (B) resyncs with the master (A).

Comments

  • tsolodovtsolodov Entrant Current User Role Beginner
    Hi,

    What file system are you using ? Is it distributed (GFS)?
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.