1, MySQL synchronization data is contained Server-id, to identify which server the statement was originally written from, so Server-id must have
2, each synchronization of the slave on the master has a master thread, the thread is identified by the slave Server-id, each slave on the master side has a maximum master thread, If the two slave have the same server-id, the last one will be kicked off when the connection succeeds. There's at least one consideration here.
Slave active Connection Master, if the slave above performs a slave stop, the connection is broken, but the corresponding thread on master does not exit, and when slave start, master can no longer create a thread and retain the original thread. There may be problems with that synchronization;
3, in MySQL master synchronization, a number of main needs to form a ring, but when synchronizing to ensure that a data does not fall into the cycle of death, here is to rely on Server-id to achieve
The role of MySQL Server-id