Tài liệu High Availability MySQL Cookbook phần 8

MySQL replication in anything but an extremely simple setup with one master handling every
single write. A guarantee of no writes being made to other nodes is highly prone to a couple
of failures. In this recipe, we look at the most common causes of replication failure that can
be prevented with some useful tricks.
This section shows how to solve auto increment problems in multi-master setups, and also
how to prevent the data on MySQL servers, which you wish should remain read-only, from
being changed (a common cause of a broken replication link). Auto-increment is the single
largest cause of problems.