Appendix C. Highly Available Architectures
In this appendix, we will show very briefly some architectures that are worth considering, with some pros and cons for each.
For the purpose of this appendix, a site is a single geographical location within which it is possible to have very high-bandwidth and low-latency connections over trusted network infrastructure.
Single-site architectures
There are various single-site architectures available, as described in this section:
MySQL master / slave replication
This replication has two servers—one master and one slave, and an application connecting to an IP address of the master as follows:
This is the most simple ...
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.
