MySQL Replication not working on binlog-do-db

Asked Feb 24 '12 at 08:59

Active Mar 16 '12 at 07:24

Viewed 877 times

I set up MySQL master-master replication on my 2 Ubuntu VM. Configuration and connection done correctly according to this guide. Here is my problem.

I print the master status on master 1 and it gives position XXX, then I jump to Master 2 and print slave status it is also prints its position as XXX.
I change any configuration beside the must-replicated db position changes. (As usual)
Problem is this when I insert any record to must-replicated db position does not change. Also record does not replicated to Master 2 must-replicated DB.

In logs also it does not give any info about replication.

Here is my 1st master-slave configuration in my.conf files:

Master:

log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=REPLICATE_DB
server-id=1

Slave:

server-id=2
master-host=10.1.1.171
master-user=slave_user
master-password=your_password
master-connect-retry=60
replicate-do-db=REPLICATE_DB

edited Mar 16 '12 at 07:24

gideon

1,135
2
13
28

asked Feb 24 '12 at 08:59

barisinanc

1

check on master 1 and master 2 the Slave_IO_Running & Slave_SQL_Running via slave status, make sure it's YES. if one of them is NO, check your setup again. – chocripple Feb 24 '12 at 09:19
these are both yes – barisinanc Feb 24 '12 at 09:44
have you try to recreate the db ?, is it sync ? if yes, try to insert records. – chocripple Feb 24 '12 at 10:08
they are sync, when i insert records database just do nothing for replication. I cannot see any action on logs or database. – barisinanc Feb 24 '12 at 13:51
remove replicate-do-db and have you try using another option like replicate-wild-do-table=db_name.% and replicate-ignore-db ? – chocripple Feb 26 '12 at 03:47

MySQL Replication not working on binlog-do-db

0 Answers0