MySQL Forums
Forum List  »  Replication

mysql replica is running but the data not updated
Posted by: amna sayed
Date: March 06, 2018 09:06AM

I have 2 MySQL replicas on 2 Linux servers

Server1 contain masterA DB1& DB2 , slaveB DB3 and some tables of DB4

Server2 Contain masterB DB3 and DB4 , slaveA some tables of DB1/DB2

Replic A staus is running and data is syncing but for Replica B status is running but data not sync specially MyIsam tables.

it's so wired issue the replications look like are running and no errors but some some tables not updated, How can i solve this issue?

Those the my.cnf files for 2 servers server1 my.cnf

server-id = 1
##Master info##
log-bin=mysql-bin
binlog_format=ROW
expire_logs_days = 3
max_binlog_size = 100M
##Slave info##
relay_log=relay-log
replicate-do-db=DB3
replicate-wild-do-table=DB4.tb1
replicate-wild-do-table=DB4.tb2
replicate-wild-do-table=DB4.tb3
Server2 my.cnf

server-id=3
# Master Info #
log-bin=mysql-bin
binlog_format=ROW
expire_logs_days = 30
max_binlog_size = 100M
##Slave Info##
relay_log=relay-log
replicate-wild-do-table=DB1.tb1
replicate-wild-do-table=DB1.tb2
replicate-wild-do-table=DB1.tb3
replicate-wild-do-table=DB1.tb4
replicate-wild-do-table=DB2.tb1
replicate-wild-do-table=DB2.tb2

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql replica is running but the data not updated
1939
March 06, 2018 09:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.