blog

Webinar Replay: Galera Cluster Best Practices – Zero Downtime Schema Changes

Jean-Jérôme Schmidt

Published

Thanks to everyone who attended yesterday’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

 

 

 

 

 

Thanks again to our speaker, Seppo Jaakola from Codership, the creators of Galera Cluster, for this in-depth talk on Galera Cluster Best Practices – Zero Downtime Schema Changes.

Webinar topics covered

  • 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

Watch the replay

Read the slides

 

If you have any additional questions, feel free to contact us or post them below in the comments section.

About Galera Cluster

Galera Cluster for MySQL is a true multi-master MySQL replication plugin, and has been proven in mission-critical infrastructures of companies like Ping Identity, AVG Technologies, KPN and HP Cloud DNS. Read the Galera tutorial for more information.

 

If you would like to install Galera Cluster, please feel free to use our Online Galera Configurator, a one page wizard with a sleek new look. Galera comes in 3 flavours, the Configurator supports all of them:

  • Galera Cluster for MySQL (Codership)
  • MariaDB Cluster
  • Percona XtraDB Cluster

Happy clustering!

 

Subscribe below to be notified of fresh posts