MySQL Forums
Forum List  »  Replication

Replication hierarchy
Posted by: Khurram Naseem
Date: August 03, 2016 03:36AM

Hi,



I've setup an AWS RDS instance as master let say M1,

I created its Read replica (R1) (this is basically a salve) and enable backup option there to make it master of below db.

I install MySQL 5.7 (to setup Multi-master replication) on EC2 (name S2) and stop replication on R1 ,note down show master status value & take backup (I note show master status change by time to time).

Restore it on S2 and enable replication on R1 again now my S2 is getting data from R1 and suddenly it stop working and gives me following error.


"Could not execute Update_rows event on table db_name.table_name; Can't find record in 'table_name', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin-changelog.001367, end_log_pos 37973062"

Why I'm getting above error?

I've following configuration on S2.

log-bin=mysql-bin
binlog_do_db=db1
binlog_do_db=db2
binlog_do_db=db3

log-slave-updates

replicate-wild-do-table=db1.%
replicate-wild-do-table=db2.%
replicate-wild-do-table=db3.%
replicate-wild-do-table=db4.%


M1 (Master) ----------> R1 (Slave/Read Replica)
|
|
|
|
v
S2 (Multi-Master Replication on EC2)


Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication hierarchy
1440
August 03, 2016 03:36AM


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.