mysql 双主同步失败_关于SQLyog操作Mysql双主、主从同步异常问题

本人遇到的问题发生在mysql 5.6.21 M-M中:

Master1 Server version: 5.6.21-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Master2 Server version: 5.6.21-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Master1 Os version: CentOS release 6.5 (Final)

Master2 Os version: CentOS release 6.5 (Final)

同步相关参数：

Master1：

server-id=1

log-slave-updates

auto_increment_increment=2

auto_increment_offset=1

replicate-do-db=*****

relay_log_recovery

Master2：

server-id=2

log-slave-updates

auto_increment_increment=2

auto_increment_offset=2

replicate-do-db=*****

relay_log_recovery

问题描述：

SQLyog对Master1做DML操作时，记录未同步到Master2对应库表里；使用其他工具操作mysqlÿ