Chinaunix

标题: mysql 双向同步问题.... [打印本页]

作者: iwlk    时间: 2008-07-09 14:38
标题: mysql 双向同步问题....
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    时间: 2008-07-09 16:51
Client requested master to start replication from impossible position

重新设置一下master_log_pos吧。




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2