Back to Webinars

Migrating to Galera Cluster for MySQL and MariaDB

Bart Oles
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "Migrating to Galera Cluster for MySQL and MariaDB", 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.
Posted in:
MySQL MariaDB Galera percona MySQL Cluster Galera Cluster percona xtradb webinar

Galera Cluster is a mainstream option for high availability MySQL and MariaDB. And though it has established itself as a credible replacement for traditional MySQL master-slave architectures, it is not a drop-in replacement.

While Galera Cluster has some characteristics that make it unsuitable for certain use cases, most applications can still be adapted to run on it.

The benefits are clear: multi-master InnoDB setup with built-in failover and read scalability.

But how do you migrate? Does the schema or application change? What are the limitations? Can a migration be done online, without service interruption? What are the potential risks?

In this webinar, Severalnines Support Engineer Bart Oles walks you through what you need to know in order to migrate from standalone or a master-slave MySQL/MariaDB setup to Galera Cluster.

Agenda

  • Application use cases for Galera
  • Schema design
  • Events and Triggers
  • Query design
  • Migrating the schema
  • Load balancer and VIP
  • Loading initial data into the cluster
  • Limitations:
    • Cluster technology
    • Application vendor support
  • Performing Online Migration to Galera
  • Operational management checklist
  • Belts and suspenders: Plan B
  • Demo
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.
Learn more