MySQL Forums
Forum List  »  NDB clusters

Please help: Nodes out of sync
Posted by: Jeff Steele
Date: November 10, 2020 09:11PM

I started this thread but did not get any responses:

https://forums.mysql.com/read.php?25,690771,690771#msg-690771

I know everyone is busy but I would really appreciate any assistance that can be offered.

In short, I upgraded from version 8.0.20 to version 8.0.22, I had a nightly backup script and the night after the backup, my primary node crashed during the backup. I didn't notice that and the next night the secondary node crashed, putting my cluster out of service.

At first, I didn't realize that the primary node had crashed a day earlier, so I started that one first. It started, but was missing a day's worth of data The secondary node would crash every time I tried to start it. I finally started it with "--initial" and it started.

However, now the secondary node has much less data than the primary node. I am concerned that if I have to stop the primary node, my application will not have the full data available to it. Can anyone please let me know what I should do in this situation?

Thanks much!

Options: ReplyQuote


Subject
Views
Written By
Posted
Please help: Nodes out of sync
266
November 10, 2020 09:11PM


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.