Syncing back up from 2 primary nodes

clee

If you had a splintered network and had 2 databases that both thought they were the primary and had secondaries under them.

Primary1 edits row with key 1 with new values, Primary2 edits row with key 2 with new values.

The network gets fixed and Primary2 detects this and becomes a secondary back under Primary1, how do they sync up at this point?

Will you get the most recent value of row with key 1 from Primary1 and the most recent value of row with key 2 from Primary2, or will you get both values from one db that was the most recently updated?

Thanks.

Bernardo

The scenario above does not happen with LiteSync. Only one primary node is supported for each database, and it is defined manually. There is no automatic change between roles.