Replication Topologies
So far you have looked at a simple two-server replication topology, like this:
A → B
where machine A is the master, and it replicates to machine B.
This is the simplest, easiest to set up, replicating pair.
Multislave
It's possible to set up a single master with any number of slaves. The architecture would look like this:
You would configure the master in the same way as explained previously. For the slaves, the only critical thing to ensure is that they each have a unique server-id.
In this model, any update that occurs in the master A is replicated to slaves B, C, and D.
Such a system is a good model for a load-balanced ...
Get Sams Teach Yourself MySQL in 21 Days, Second Edition 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.
