US 11,989,205 B2
Data replication in an active-active databases
Xin Xin Dong, Beijing (CN); Mai Zeng, Beijing (CN); Xing Jun Zhou, Shanghai (CN); Ming Qiao Shang Guan, Beijing (CN); Wei Song, Beijing (CN); and Cheng Fang Wang, Beijing (CN)
Assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Jun. 2, 2022, as Appl. No. 17/805,048.
Prior Publication US 2023/0394062 A1, Dec. 7, 2023
Int. Cl. G06F 16/27 (2019.01)
CPC G06F 16/27 (2019.01) 14 Claims
OG exemplary drawing
 
1. A method for data replication in an active-active databases having a source site and a target site, the method comprising:
creating, by a subscription activation module of the source site of the active-active databases, a subscription activation message in a capture address space, the subscription activation message having a timestamp after a latest committed timestamp of the active-active databases;
transmitting, by a subscription activation module of the source site of the active-active databases, the subscription activation message to a subscription activation module of the target site of the active-active databases;
based on a determination, by a subscription verification module of the source site and a subscription verification module of the target site, that one or more tables associated with the subscription activation message are inactive, repairing, by a subscription repair module, the one or more tables;
based on a determination, by the subscription verification module of the source site and the subscription verification module of the target site, that all tables associated with the subscription activation message are active, initiating replication of the capture address space from the source site to the target site with a timestamp of the latest committed timestamp; and
creating an inactive subscription table, by the subscription verification module of the source site and the subscription verification module of the target site, based on the determination that one or more subscriptions associated with the subscription activation message are inactive, wherein each entry of the inactive subscription table includes a subscription number, a table name, and a root cause why an inactive table could not be activated.