Automatically restoring data replication consistency without service interruption during parallel apply
A data replication method can begin with the detection of an inconsistency between records of a target table and corresponding records of a source table of a relational database management system (RDBMS) performing a parallel apply replication by an improved data replication manager. The target table can be a copy of the source table, both of which include multiple unique constraints and indexes. A timeframe that encompasses the records of the target table having the inconsistency can be determined. The timeframe can utilize a commit timestamp or a log sequence number. Consistency between the target table and the source table can be automatically restored for the determined timeframe through use of a reactive-apply process. Data suppression for updates is automatically restored once the copy is consistent. Transactions performed upon the target table by the reactive-apply process can be performed in parallel. Service at the source table and the target table can be uninterrupted.
1. A method comprising:
utilizing a reactive apply algorithm to resolve unique constraint/index violations encountered due to target point in time inconsistencies from a fuzzy copy on a target table of a relational database management system (RDBMS);
the reactive apply process first eliminating a possibility of a unique index violation occurring purely due to out-of-order parallel apply;
detecting of an inconsistency between records of the target table and corresponding records of a source table of the RDBMS by an improved data replication manager, wherein the target table is a copy of the source table, wherein the source and the target tables comprise a plurality of multiple column unique indexes one of which is used as the replication key, wherein the target table is the fuzzy copy, which is an initial copy of data from the source table, wherein the fuzzy copy is not point-in-time consistent with the source table and is not a snapshot copy of the source table;
determining a timeframe that encompasses the records of the target table having the inconsistency, wherein said timeframe is delimited using one of a commit timestamp and a log sequence number; and
automatically restoring consistency between the target table and the source table for the determined timeframe through use of a capture-apply process, wherein transactions performed upon the target table by the capture-apply process are performed in parallel, wherein service at the source table and the target table is uninterrupted.