MySQL Forums
Forum List  »  Replication

mysql-backup-restore-on-multiple-host-in-live-replication
Posted by: avik biswas
Date: March 04, 2021 04:47PM

MySQL database has 1 primary host which is replicating to 2 Read replicas

RR1
RR2
RR1 is master of RR11 RR12 RR13

RR2 is master of RR21 RR22 RR23

I have to make a schema change so I started schema change in RR13 by stopping replication. Then I made schema change, loaded data back & started replication. Its all working good.

Now I want to restore this host schema with Data to rest of everything. Can someone help me with the process? I was planning to do the same on RR12 RR11 but not sure how to do on master RR1 & the other branch hosts(RR2 branch hosts)

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql-backup-restore-on-multiple-host-in-live-replication
679
March 04, 2021 04:47PM


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.