Advanced MySQL 8

Multi-source replication

As shown in the previous diagram, in this replication mechanism more than one master can replicate data to a single slave in parallel. One slave receives all the transactions at the same time. It is not compatible with a file-based replication mechanism, but we can configure GTID-based replication or binary log-based replication in masters. The slave maintains table repositories for master information and relay log information.

Use cases for multi-source replication include the following:

• Backing up multiple servers to a single server
• Merging table shards
• Consolidating data

In a multi-source replication mechanism, there is no in-built conflict detection or resolution when applying transactions from multiple sources. ...