We have a master-master replication during database migration, now we want to change back to master-slave. After change auto_increment_incremen and auto_increment_offset to 1 on both database, the application sometimes got below error. Application only connect to the master for write.
Uncaught PDOException: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry ‘72141167’
If we change auto_increment_incremen back to 2 then error disappeared.
5.7.19-17,Percona Server (GPL), Release 17, Revision e19a6b7b73f