How do you design an active-active multi-region database deployment?

Question

Accepted Answer

Active-active means every region accepts writes; active-passive means one region writes and the others hold replicas ready to be promoted. Active-active buys low write latency everywhere and survives a region loss with near-zero RTO — at the cost of conflicts, which physics guara