US 10,949,416 B2Granted

Workload management across multiple data sites capable of providing active services

AssigneeInternational Business Machines Corporation

InventorsSi Bin Fan, Wei Liu, Mai Zeng, Wen Z. Liu, Wei Li, Yi J. Yj, Zhi D. Hao, Hong Tao Li, Jiong Fan, Wei H. Liu

Life of this patent

Estimating the term…

Loading patent…

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.

Claims20

Dependent claims

A computer-implemented method for implementing an active-active transaction protocol for multiple sites, the method comprising:

receiving a transaction at a first transaction routing control layer associated with a first site, wherein the transaction comprises a modification to a first data record and a modification to a second data record, and wherein the first data record and the second data record are each stored at the first site and a second site;
determining that no affinity record exists for the first data record or the second data record;
transferring a transaction control flow to a second transaction routing control layer associated with the second site;
generating and storing, at the second site, a first affinity record corresponding to the first data record and the transaction and a second affinity record corresponding to the second data record and the transaction, wherein the first affinity record and the second affinity record each point to the first site;
transferring the transaction control flow back to the first transaction routing control layer;
generating and storing, at the first site, a third affinity record corresponding to the first data record and the transaction and a fourth affinity record corresponding to the second data record and the transaction, wherein the third affinity record and the fourth affinity record each point to the first site;
and
routing the transaction to a first transaction server associated with the first site to initiate execution of the transaction.

5 more elements

A system for implementing an active-active transaction protocol for multiple sites, the system comprising:

at least one memory storing computer-executable instructions;
and
at least one processor, wherein the at least one processor is configured to access the at least one memory and execute the computer-executable instructions to:
receive a transaction at a first transaction routing control layer associated with a first site, wherein the transaction comprises a modification to a first data record and a modification to a second data record, and wherein the first data record and the second data record are each stored at the first site and a second site;
determine that no affinity record exists for the first data record or the second data record;
transfer a transaction control flow to a second transaction routing control layer associated with the second site;
generate and store, at the second site, a first affinity record corresponding to the first data record and the transaction and a second affinity record corresponding to the second data record and the transaction, wherein the first affinity record and the second affinity record each point to the first site;
transfer the transaction control flow back to the first transaction routing control layer;
generate and store, at the first site, a third affinity record corresponding to the first data record and the transaction and a fourth affinity record corresponding to the second data record and the transaction, wherein the third affinity record and the fourth affinity record each point to the first site;
and
route the transaction to the first site to initiate execution of the transaction.

8 more elements

A computer program product for implementing an active-active transaction protocol for multiple sites, the computer program product comprising a storage medium readable by a processing circuit, the storage medium storing instructions executable by the processing circuit to cause a method to be performed, the method comprising:

receiving a transaction at a first transaction routing control layer associated with a first site, wherein the transaction comprises a modification to a first data record and a modification to a second data record, and wherein the first data record and the second data record are each stored at the first site and a second site;
determining that no affinity record exists for the first data record or the second data record;
transferring a transaction control flow to a second transaction routing control layer associated with the second site;
generating and storing, at the second site, a first affinity record corresponding to the first data record and the transaction and a second affinity record corresponding to the second data record and the transaction, wherein the first affinity record and the second affinity record each point to the first site;
transferring the transaction control flow back to the first transaction routing control layer;
generating and storing, at the first site, a third affinity record corresponding to the first data record and the transaction and a fourth affinity record corresponding to the second data record and the transaction, wherein the third affinity record and the fourth affinity record each point to the first site;
and
routing the transaction to a first transaction server associated with the first site to initiate execution of the transaction.

5 more elements

Dependencies are inferred from the claim text.