MySQL Forums
Forum List  »  Replication

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Adding a new server to Replication Group from mysqldump
740
C S
September 25, 2018 03:28PM


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.