Databases Reference
In-Depth Information
Figure 10-9. A replication ring topology
You can mitigate some of the risk of a ring replication setup by adding replicas to
provide redundancy at each site, as shown in
Figure 10-10
. This merely protects against
the risk of a server failing, though. A loss of power or any other problem that affects
any connection between the sites will still break the entire ring.
Figure 10-10. A replication ring with additional replicas at each site
Master, Distribution Master, and Replicas
We've mentioned that replicas can place quite a load on the master if there are enough
of them. Each replica creates a new thread on the master, which executes the special