How to solve the problem of mysql master-master synchronization and slave database out-of-synchronization?
There are now 3 mysql instances mysql-m1 mysql-s1 mysql-m2
mysql-m1 and mysql-s1 are master-slave relationships. All operations in mysql-m1 will be synchronized to mysql-s1, and then I configured mysql-m2 and mysql-m1 as Master-Master relationship, inserting data into mysql-m2 will be synchronized to mysql-m1 but mysql-s1 is not synchronized (mysql-m1 and mysql-s1 are Master-slave relationship, right? Because the data synchronized by binlog will no longer be recorded in binlog, the slave database mysql-1 is not synchronized). Do I need to add a master-slave relationship between mysql-m2 and mysql-s1 to achieve the effect I want? Or is there another solution? Ask God for answers!
