Galera cluster best practices: zero downtime schema changes

Johan Andersson
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "Galera cluster best practices: zero downtime schema changes", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

Galera Cluster is good at making your MySQL database HA, but what about schema changes? Is an ALTER TABLE statement something that requires a lot of advance scheduling? What is the impact on database uptime? Watch this webinar and learn how to do schema changes in your MySQL Galera cluster with maximum uptime and full data consistency.

Agenda

  • How to perform Zero Downtime Schema Changes
  • 2 main methods: TOI and RSU
  • Total Order Isolation: predictability and consistency
  • Rolling Schema Upgrades
  • pt-online-schema-change
  • Schema synchronization with re-joining nodes
  • Recommended procedures
  • Common pitfalls/user errors
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.