Adding a new server to Replication Group from mysqldump
Posted by:
C S
Date: September 25, 2018 03:28PM
Hi,
With a long history it is not as convenient to add a new blank server but copy the databases and continue the replication well into the future.
With Masters and Slaves you would:
lock tables,
record the log_file and log_pos
mysqldump an old master
unlock tables
splat the databases onto the new server
set the log_file and log_pos
start the slave/master
But things seem different now and attempting this has met me with failure. Any advice?
Subject
Views
Written By
Posted
Adding a new server to Replication Group from mysqldump
999
September 25, 2018 03:28PM
395
November 05, 2018 11:33AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.