Setting up replication

There are many replication topologies. Some of them are the traditional master-slave replication, chain replication, master-master replication, multi-source replication, and so on.

Traditional replication involves a single master and multiple slaves.

Chain replication means one server replicates from another, which in turn replicates from another. The middle server is referred to as the relay master (master ---> relay master ---> slave).

This is mainly used when you want to set up replication between two data centers. The primary master and its slaves will be in one data center. The secondary master (relay) replicates from the primary master in the other data center. All the slaves of the other data center are replicated from the secondary master.

Master-master replication: In this topology, both the masters accept writes and replicate between each other.

Multi-source replication: In this topology, a slave will replicate from multiple masters instead of one.

If you...