Designing slave in multiple continents
When you want to build a geographical distant architecture, you need to think about several things:
- Should I replicate everything?
- Is write speed important?
- What is the expected read load for each site?
The following figure shows an example with a French Datacenter where we've got the master node and several slaves that distribute information to other countries (Brazil and Japan):
The latency and bandwidth with such distances are problematic for replication. Consider the following important information:
- Should I replicate everything: In the previous section, we saw how to replicate only some databases or tables and ...
Get MariaDB High Performance 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.
