Chapter 8. Replication Deep Dive

Previous chapters introduced the basics of configuring and deploying replication to keep your site up and available, but to understand replication’s potential pitfalls and how to use it effectively, you should know something about its operation and the kinds of information it uses to accomplish its tasks. This is the goal of this chapter. We will cover a lot of ground, including:

  • How to promote slaves to masters more robustly

  • Tips for avoiding corrupted databases after a crash

  • Multisource replication

  • Row-based replication

  • Global transaction identifiers

  • Multithreaded replication ...

Get MySQL High Availability, 2nd Edition now with the O’Reilly learning platform.

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