MySQL Replication tuning
MySQL Replication tuning is generally focused on preventing slave servers from falling behind. This can be an inconvenience or a total disaster depending on how reliant you are on consistency (if you are completely reliant on consistency, of course, MySQL Replication is not the solution for you).
In this chapter, we focus on tips for preventing slaves from "falling behind" the master.
How to do it...
INSERT SELECT is a common and convenient SQL command, however, it it is best avoided by using MySQL Replication. This is because anything other than a trivial SELECT will significantly increase the load on the single thread running on the slave, and cause replication lag. It makes far more sense to write a SELECT and then an ...
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.
