About SQLyog operation MySQL dual master, master-Slave synchronization exception problem

The problem I encountered occurred in 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)

Synchronization related parameters:

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

Problem Description:

SQLyog the Master1 do DML operations, the records are not synchronized to the Master2 corresponding library table; Use other tools to operate MySQL, sync normal

Troubleshooting process:

1. First view the Master1 and Master2 of the master, slave status, are displayed basically normal;

Slave_io_running:yes

Slave_sql_running:yes

Slave_sql_running_state:slave have read all relay log; Waiting for the slave I/O thread to update it

2. Then view errlog, no related error message

3. Parse Master2 's relay log and Binlog with Mysqlbinlog, and find DML statement with relay tool in SQLyog log, but the DML statement is not present in Binlog

Correlation analysis:

The SQL was found in the relay of "slave", but the SQL was not found in Binlog, which indicates that the synchronization of salve I/O line logs is normal; only slave SQL thread executes SQL with exception.

but viewing the master and slave status, both display normal, and no reported error message. Find relevant information on the Internet, found several SQLyog synchronization problems more typical posts, but no solution

Method:

http://blog.csdn.net/linvo/article/details/6566215

http://bbs.csdn.net/topics/390672280

If the client-side tool causes the main master, master-Slave synchronization exception, the feeling is a bit too far-fetched, theoretically, unless it is the MySQL slave_sql_running thread

SQLyog Statement Parsing exception, skip directly SQLyog compiled SQL, so explain or feel a bit of a problem, but said back, with other tools to operate MySQL, synchronization is normal

Often. It feels a little weird anyway.

Ask the great gods to help explain the problem.

About SQLyog operation MySQL dual master, master-Slave synchronization exception problem