Related Documents
- Binary Log
- MySQL < 8.4: CHANGE MASTER TO
- MySQL > 8.4: CHANGE REPLICATION SOURCE TO
- Firewall Settings
- firewalld
- Load Balancer
- Master Configuration
- Node Provisioning
- Replication Threads
- SELinux
- MySQL < 8.4: SHOW MASTER STATUS
- MySQL > 8.4: SHOW BINARY LOG STATUS
- MySQL < 8.4: SHOW SLAVE STATUS
- MySQL > 8.4: SHOW REPLICA STATUS
- MariaDB > 10.5.1: SHOW REPLICA STATUS
- Slave Options
- State Transfer
- wsrep Options
- wsrep Options
Related Articles
Other Resources
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.
Related Documents
- Binary Log
- MySQL < 8.4: CHANGE MASTER TO
- MySQL > 8.4:: CHANGE REPLICATION SOURCE TO
- Firewall Settings
- firewalld
- Load Balancer
- Master Configuration
- Node Provisioning
- Replication Threads
- SELinux
- MySQL < 8.4: SHOW MASTER STATUS
- MySQL > 8.4: SHOW BINARY LOG STATUS
- MySQL < 8.4: SHOW SLAVE STATUS
- MySQL > 8.4: SHOW REPLICA STATUS
- MariaDB > 10.5.1: SHOW REPLICA STATUS
- Slave Options
- State Transfer
- wsrep Options
- wsrep Options
Related Articles
Other Resources