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!
m1开启log_slave_updates即可,m2->m1->s1属于级联复制了,中间节点确保开启这个参数
复制事务也会写入二进制日志的呀,你先确认下S1的同步有没有被中断吧。