Microsoft Access and SQL Server
Multi-master replication without a primary
Each row R of a table has 4 additional columns
- globally unique id (GUID)
- generation number, to determine which updates from other replicas have been applied
- version number = the number of updates to R
- array of [replica, version number] pairs, identifying the largest version number it got for R from every other replica
Uses Thomas’ write rule, based on version numbers
- Access uses replica id to break ties. SQL Server 7 uses subscriber priority or custom conflict resolution.