MySQL Forums
Forum List  »  NDB clusters

Re: ndnd no wait option implications
Posted by: Bernd Ocklin
Date: November 16, 2020 03:27AM

Hi

if you allow a partitioned start you could end up in a split brain situation and loose data.

Imagine a situation where e.g. nodes 17 and 18 are offline and 19 receives updates. Then 19 is also forced to stop. If after that 17 or 18 is allowed to start in a partitioned manner then the updates to 19 will be lost. 17 or 18 starts without those updates as there is no way for 17 or 18 to "know" about updates to 19 without a network connection to it. If 17 or 18 wait for 19 when starting they will auto-recover missing updates from 19.

This scenario is probably more unlikely with 3 replicas than with 2.

Regards
Bernd from the NDB Cluster Team at MySQL

Options: ReplyQuote


Subject
Views
Written By
Posted
322
November 13, 2020 10:07AM
Re: ndnd no wait option implications
201
November 16, 2020 03:27AM


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.