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:

MySQL master / slave replication

This is the most ...

Get High Availability MySQL Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.