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 asXXX
. - 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