Master-slave database, write the data to do the database, and the primary key of data from the database and the main database of the primary key conflict

CodePudding user response:

If required in the architecture from written material can change is given priority to, from or write data does not affect the master-slave synchronous keys

CodePudding user response:

From the library is set to read-only mode, couldn't write;
& gt; The set global read_only=1;

CodePudding user response:

Depends on how you need to solve, can decide to do,
Are you need to write the data from the library? That is double to write,
Or from the library remains read-only?

If double, double main reference architecture,
If the library remains read-only, then it will be written to the data from the library to find out from the inside of the binlog, seek development with primary key conflict, check the data to the main library, and then the reconstruction from the library,