Designing a replication setup
There are many ways to architect a MySQL Replication setup, with the number of options increasing enormously with the number of machines. In this recipe, we will look at the most common topologies and discuss the advantages and disadvantages of each, in order to show you how to select the appropriate design for each individual setup.
Getting ready
MySQL replication is simple. A server involved in a replication setup has one of following two roles:
- Master: Master MySQL servers write all transactions that change data to a binary log
- Slave: Slave MySQL servers connect to a master (on start) and download the transactions from the master's binary log, thereby applying them to the local server
Note
Slaves can themselves act as ...
Get High Availability MySQL 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.