2 ms·
What does the author think should happen here? Two servers independently committed conflicting transactions, which is always a possibility for multi-master in
by jeffdavis 11y ago
What does the author think should happen here?
Two servers independently committed conflicting transactions, which is always a possibility for multi-master in the general case. You can't have independence and dependence on the same variable at the same time.
Now, maybe BDR could do better for the case the author is concerned about, but the author hasn't explained what it should do and why it's better.
The author seems to want the entire conflicting transaction to be rejected, but it's already been committed on the remote node so I don't see how that helps. They will never be back in sync again until you sort it out.
You should use BDR in cases where you can come up with some reasonable conflict resolution. For instance, allow inventory to go negative, and inform one customer of a delay with their order.