MySQL Forums
Forum List  »  Replication

Re-clone a secondary node: what are my options?
Posted by: Geert Vanderkelen
Date: October 25, 2021 12:22AM

A secondary node fails to apply some transaction. Instead of injecting empty transactions, and try to get it going, I would like to re-sync/re-do the whole secondary node.

What are my options? Shall I wipe the disk and let it re-join so that it copies over everything new? Is there a magical trick using SQL statements which would let me do that without touching disk files?

For reasons, the data dir is mounted, so I cannot simply move it away. I can move of course all files. (yes, move, I play it save..).

Options: ReplyQuote

Written By
Re-clone a secondary node: what are my options?
October 25, 2021 12:22AM

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.