Severalnines Blog
The automation and management blog for open source databases

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

Severalnines
Posted in:

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

Percona Live 2017 - Severalnines Recap

This blog contains a recap of Severalnines participation the Percona Live 2017 Open Source Database Conference including videos and slides from our sessions.

How to deploy and manage HAProxy, MaxScale or ProxySQL with ClusterControl - Webinar May 9th

New webinar on support for proxies for MySQL HA setups in ClusterControl: how they differ and what their pros and cons are. We will also demonstrate how you can easily deploy and manage HAProxy, MaxScale and ProxySQL from ClusterControl during a live demo.

Meet the Severalnines team at M|17 and Percona Live this month

April 2017 will see the Severalnines team attend two open source database conferences, namely the MariaDB User Conference, and the Percona Live Conference. Find all details about our participation here.

Posted in:

High Availability in ProxySQL: new webinar with René Cannaò

New joint webinar with ProxySQL’s creator, René Cannaò, on how to build a highly available proxy layer with ProxySQL; and how to automate some of these processes with ClusterControl.