Standard Replication & Galera Cluster

This training video introduces standard MySQL and MariaDB replication. It explains and demonstrates how to configure two services—one master and one slave—for replication. It also contrasts replication against Galera Cluster; it talks about the advantages of Galera over standard replication. The video also explains and demonstrates how to configure three servers for Galera cluster.

As part of the training process, in the right margin here, you can find a link to a page containing exercises related to the training video. You should look at it before starting the video so that you can be prepared. There’s also a link to a PDF copy of the slide presentation. It’s been set so that you make notes on it. In the left margin are links to related documentation, articles, and other materials.

Video Specifications

  • Speaker: Russell J.T. Dyer
  • Date: October 15, 2019
  • Length of Video: 54 minutes

Student Materials

Standard Replication

1. Purpose & Advantages (time index: 3:10)
The values, the point of using replication and clusters of servers.

2. Standard Replication Layout (time index: 8:39)
An introduction to standard MySQL or MariaDB replication.

3. Configuring Replication (time index: 17:12)
The steps for configuring MySQL and MariaDB software for use in standard replication.

Galera Cluster

4. Galera Basics (time index: 34:49)
The basics — concepts and some important terms.

5. Configuring Galera (time index: 39:29)
Explanation and demonstration on configuring servers for Galera.

6. Deploying a Cluster (time index: 43:47)
Starting and testing a minimum three-node cluster.