Managing Update Conflicts for Multiple Primaries

When there are multiple primaries, design remote updates so they do not introduce errors resulting from simultaneous requests to update the same information from multiple remote sites.

If updates from two different sites conflict when they are applied at a primary site, one of the updates will be rejected, and the replicated data at the site where the update was rejected will be inconsistent with primary data.

To handle intersite concurrency conflicts when there are multiple primaries: