How do you handle a split-brain scenario in a database cluster, and what mechanisms prevent it from occurring?

Sample answer preview

Split-brain is the most dangerous failure mode in a database cluster, occurring when two nodes both believe they are the primary and accept writes independently. The resulting data divergence creates conflicting records that are extremely difficult or impossible to reconcile…