Abstract: Systems, methods, and computer-readable media are described for implementing an active-active transaction protocol according to which multiple sites can each provide active services such as executing update transactions that insert, modify, or delete data records. An active-active transaction protocol utilizes affinity records corresponding to both transactions that have been received as well as the data records those transactions are updating to determine which site should handle execution of an incoming update transaction. An affinity record defines a relationship between a data record and a site that determines whether and where a transaction seeking to update that data record will be routed for processing. Conflict handling mechanisms are also provided by the active-active transaction protocol to ensure data consistency between the multiple sites.

Abstract: Systems, methods, and computer-readable media are described for implementing an active-active transaction protocol according to which multiple sites can each provide active services such as executing update transactions that insert, modify, or delete data records. An active-active transaction protocol utilizes affinity records corresponding to both transactions that have been received as well as the data records those transactions are updating to determine which site should handle execution of an incoming update transaction. An affinity record defines a relationship between a data record and a site that determines whether and where a transaction seeking to update that data record will be routed for processing. Conflict handling mechanisms are also provided by the active-active transaction protocol to ensure data consistency between the multiple sites.