MySQL master-slave architecture of the Master-master Mutual primary preparation

Master-master Mutual Primary Preparation

1: According to the master and slave configuration steps to configure Masterb to Mastera from the library;

2: Make sure that Masterb is not written, get its sync point on Masterb by the show Master Status command, and then configure Mastera to Masterb from the library.

In general, in order to simplify logic, one of the master is set to read-only and is read and written only by another master. To write on both sides, in order to avoid self-increment ID collisions, it is common to set parity, that is, the self-increment ID of one is odd and the other is even.

MySQL master-slave architecture of the Master-master Mutual primary preparation