Master-Master Replication Problem

I have configured 2 MySQL server to do master-master replication. Below
is my config:
Node A
server-id = 1
log_bin = mysql-bin
expire_logs_days = 10
max_binlog_size = 100M
binlog_do_db = clustertest
binlog_do_db = gateway
binlog_do_db = reporting
binlog_do_db = traffic
binlog_ignore_db = mysql
binlog_ignore_db = test
replicate-same-server-id = 0
log-slave-updates
auto-increment-increment = 10
auto-increment-offset = 1

master-host = 10.1.20.103
master-user = replicator
master-password = username
master-port = 3306
replicate-do-db = clustertest
replicate-do-db = gateway
replicate-do-db = reporting
replicate-do-db = traffic



Node B
server-id = 2
log_bin = mysql-bin
expire_logs_days = 10
max_binlog_size = 100M
binlog_do_db = clustertest
binlog_do_db = gateway
binlog_do_db = reporting
binlog_do_db = traffic
binlog_ignore_db = mysql
binlog_ignore_db = test
replicate-same-server-id = 0
log-slave-updates
auto-increment-increment = 10
auto-increment-offset = 2

master-host = 10.1.20.102
master-user = replicator
master-password = username
master-port = 3306
replicate-do-db = clustertest
replicate-do-db = gateway
replicate-do-db = reporting
replicate-do-db = traffic


I restart MySQL daemon, and go to mysql shell and execute this on both
server:
Node A
flush tables with read lock;
show master status \G

Node b
stop slave
CHANGE MASTER TO MASTER_HOST='10.1.20.102', MASTER_USER='replicator',
MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=98;
start slave

I went back to Node A and execute unlock tables;

Node B
flush tables with read lock;
show master status \G

Node A
stop slave
CHANGE MASTER TO MASTER_HOST='10.1.20.103', MASTER_USER='replicator',
MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=98;
start slave

I went back to Node B and execute unlock tables;

After that I try to insert new record from Node A and I see Node B is
synchronized. But when I try to insert new record from Node B. I see
nothing change at Node A. What I missed here?



Willy



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org