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.
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
Slaves can themselves act ...