mysql-backup-restore-on-multiple-host-in-live-replication
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)
Subject
Views
Written By
Posted
mysql-backup-restore-on-multiple-host-in-live-replication
524
March 04, 2021 04:47PM
226
March 04, 2021 06:29PM
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.