Restoring database consistency integrity

Patent metadata

Field	Value
Publication number	US-9858305-B2
Application number	US-201414199370-A
Country	US
Kind code	B2
Filing date	Mar 6, 2014
Priority date	Mar 6, 2014
Publication date	Jan 2, 2018
Grant date	Jan 2, 2018

Abstract

Techniques for restoring point-in-time and transaction consistency across consistency groups between a first and a second independent database management system (DBMS) for a disaster recovery. Several consistency groups (CGs) are defined for replication. For each CG in the first DBMS data changes are transmitted to a second DBMS. A timestamp representing a most recently received commit log record or a heartbeat during periods of inactivity for a CG is stored in a database table at regular intervals. At regular intervals, the timestamp is compared with timestamps for other CGs to identify a common time at which data to be applied to the CGs in the second DBMS have been received into a recoverable data store. The received data is applied to the CGs in the second DBMS up to the common time.

First claim

What is claimed is:

1. A computer program product for restoring transaction consistency across consistency groups between a first and a second independent database management system for a disaster recovery, wherein the first and second independent database management systems operate in an active/active configuration, the computer program product comprising a computer readable storage medium having program code embodied therewith, the program code being executable by a processor to perform a method comprising:
defining, by the processor, a plurality of consistency groups, wherein each consistency group in the first database management system includes system, middleware and application volumes to be managed as a consistent entity, and wherein each consistency group uses a separate transmission channel to transmit data changes pertaining to the consistency group to a corresponding consistency group at the second database management system;
in response to the second database management system having received data from log records from the first database management system, identifying, by the processor, a timestamp representing a most recently received commit log record and storing the timestamp in a database table;
comparing, by the processor, the timestamp with timestamps for other consistency groups to identify a lowest common commit point representing a common time at which data to be applied to the consistency groups in the second database management system have been received into a recoverable data store; and
applying, by the processor, the received data to the consistency groups in the second database management system up to the identified lowest common commit point.

2. The computer program product of claim 1 , wherein applying the received data to the consistency groups in the second database management system is performed only in response to having received timestamps for each consistency group in the second database management system.

3. The computer program product of claim 1 , wherein the method performed by the processor further comprises:
sending a heartbeat message with a timestamp greater than a last replicated commit timestamp for a consistency group in response to determining that there is no data to replicate for the consistency group.

4. The computer program product of claim 1 , further comprising program code executable by the processor to perform a method comprising:
temporarily persisting, by the processor, the received data in a recoverable staging area; and
independently selecting from the staging area, by one or more replication apply programs, subsets of the received data to be applied to the consistency groups in the second database management system.

5. The computer program product of claim 4 , wherein the recoverable staging area is located in one of: the second database management system, and in a queuing system.

6. The computer program product of claim 4 , wherein:
the replication apply programs are operable to suspend an apply in response to data having been applied up to the identified lowest common commit point, and
the suspended apply lasts until the replication apply programs determine a subsequent lowest common commit point to which changes are to be applied.

7. The computer program product of claim 4 , further comprising program code executable by the processor to perform a method comprising:
monitoring, by the processor, the state of the staging area to determine whether the lowest common commit point for which all messages containing sub-transactions to be applied in the second database management system has been received.

8. The computer program product of claim 7 , further comprising program code executable by the processor to perform a method comprising:
in response to determining that the lowest common commit point for which all messages containing sub-transactions to be applied in the second database management system have been received, notifying, by the processor, the other participant apply programs and applying, by the replication apply programs the subsets of data to the consistency groups in the second database management system.

9. The computer program product of claim 1 , further comprising program code executable by the processor to perform a method comprising:
prior to failover for a disaster from the first database management system to the second database management system, discarding, by the processor, changes beyond the lowest common commit point among all transmission channels.

Assignees

• IBM

Inventors

• Bourbonnais Serge
• D'Costa Austin F M
• Fuh You-Chin
• Teng James Z
• Yu Tyrone

Classifications

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F11/1474

  in transactions (updating of structured data in databases G06F16/23) · CPC title

• G06F17/30578

  Physics · mapped topic

• G06F17/30575

  Physics · mapped topic

• G06F11/2094 Primary

  Redundant storage or storage space (G06F11/2056 takes precedence) · CPC title