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. ...

Get MySQL 8 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.