mysql 双向同步问题....

iwlk

A
===========================
server-id=1
log-bin=sync.log
binlog-do-db=ddns


replicate-do-db=ddns
master-connect-retry=60
master-host=xxx.xxx.xxx.11
master-port=3306
master-user=xxx
master-password=password


B
===========================
server-id=2
replicate-do-db=ddns
master-connect-retry=60
master-host=xxx.xxx.xxx.10
master-port=3306
master-user=xxx
master-password=password

log-bin=sync.log
binlog-do-db=ddns


A->B 正常
B->A 数据没有同步过来.

已测试,如果是单向的. B->A 正常.

A日志中有个错误,即
-----------------------------
Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log

For more information, see Help and Support Center at http://www.mysql.com

yueliangdao0608

Client requested master to start replication from impossible position

重新设置一下master_log_pos吧。