Severalnines Blog
The automation and management blog for open source databases

Webinar Replay & Slides: Galera Cluster Best Practices - Zero Downtime Schema Changes

Severalnines
December 05, 2013
Posted in: Events

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!

 

Related Post

How to build a stable MySQL Replication environment

Severalnines
November 29, 2016

During this webinar, participants will learn how to build a production-ready environment with MySQL replication. From OS and DB configuration checklists to schema changes and disaster recovery, they’ll have the information needed to plan and prepare the best setup for their requirements.

Posted in: DB Ops Events

Top 9 Tips for building a production-ready MySQL Replication environment

Severalnines
November 22, 2016

Join our new webinar during which we’ll cover our 9 Top Tips on how to build a stable MySQL Replication environment. From OS and DB configuration checklists to schema changes and disaster recovery,  you’ll have the tips needed for a production-ready replication setup.

Posted in: DB Ops Events

Webinar: Become a MongoDB DBA - Scaling and Sharding

Severalnines
October 27, 2016

In this third webinar of the ‘Become a MongoDB DBA’ series, we will focus on scaling and sharding your MongoDB setup.

Posted in: DB Ops Events MongoDB

Completing the MySQL Query Tuning Trilogy: working with optimizer & SQL tuning

Severalnines
October 27, 2016

This webinar was the third and last part of our webinar trilogy on MySQL Query Tuning, in which we discussed query tuning and related tools. In this trilogy we’ve covered SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 3 focussed on working with the optimizer and SQL tuning.

Posted in: DB Ops Events