The Library

High Availability with Galera Cluster

The MySQL Server High Availability landscape provides with a slew of tools to help you ensure that your databases keep humming. Such tools are Galera Cluster, however, it is worth looking at semi-synchronous replication with failover tools, and also the usual leader-follower asynchronous replication. Today more workloads are moving to the cloud, and what failover options do you get with Amazon RDS for MySQL or even Aurora? What about the newfangled group replication and InnoDB Cluster? And let us not forget that Galera Cluster has spawned branches too!

Video Specifications

  • Speaker: Colin Charles
  • Date: April 10, 2019
  • Length of Video: 60 minutes

1. Codership (time index: 1:04)
Brief introduction to Codership, the creators and developers of Galera Cluster.

2. What is High Availability (time index: 2:50)
Discussion of the fundamentals of High Availability—the value and goals—as well as how it’s achieved generally.

3. Redundancy Through MySQL Replication (time index: 19:22)
Covers briefly how standard replication may be used for maintaining high availability.

4. Failover Frameworks (time index: 21:55)
Discusses methods by which failed servers, in particular a primary, may be replaced—including common difficulties one may encounter.

5. Proxies (time index: 25:05)
Explains how proxies may be used for directing traffic among multiple servers, and redirecting away from a down server.

6. Galera Cluster (time index: 27:13)
Introduction to Galera Cluster and how high availability can be achieved so easily with it, as well as an explanation of how Galera works.

7.**Cloud-Based Solutions (time index: 45:37)
Explains how Galera Cluster may be used on a cloud situation, how a cloud-based cluster can solved problems, as well as how to make use of them.