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


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


Sorry, only registered users may post in this forum.

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.