List:General Discussion« Previous MessageNext Message »
From:sangprabv Date:June 20 2009 12:50am
Subject:Master-Master Replication Problem
View as plain text  
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


Thread
Master-Master Replication Problemsangprabv20 Jun