Replication for on-line hot-standby database
First Claim
1. A computer system for replicating a database image from an operational primary node in a distributed database environment, said computer system comprising:
- one or more computer processors; and
one or more computer-readable storage media;
wherein program instructions are stored on the computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising instructions to cause the at least one of the one or more computer processors to;
define a checkpoint image of the primary node including a database structure and a plurality of database pages;
create a replica database on a backup node by initiating a backup node and saving the defined database structure on the initiated backup node;
send each database page of the checkpoint image to the backup node for saving;
save, after creation of a checkpoint image is started, each subsequent transaction on the primary node thereby creating a corresponding REDO transaction for sending to the backup node;
identify each data page operated on by each subsequent transaction;
send, in parallel with the sending of the database pages, each created REDO transaction to the backup node in the order in which the corresponding transaction occurred so that the backup node can replicate the transactions in the correct order; and
prioritize each identified database page so that it arrives at the backup node before or substantially at the same time as a corresponding REDO transaction whereby the corresponding REDO transaction can operate on the identified database page without waiting for every database page to be saved on the backup node.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, and corresponding computer program product and computer system, for replicating a database image in a distributed database environment comprises: defining a checkpoint image of the primary node including a database structure and a plurality of database pages; creating a replica database by initiating a backup node and saving the defined structure on the initiated backup node; sending each database page of the checkpoint image for saving on the backup node; saving every transaction on the primary node and creating a corresponding REDO transaction; identifying each data page operated on by each REDO transaction; sending each created REDO transaction to the backup node in the order in which the corresponding transaction occurred, and prioritizing each identified database page so that it arrives at the backup node before or substantially at the same time as a corresponding REDO transaction.
-
Citations
20 Claims
-
1. A computer system for replicating a database image from an operational primary node in a distributed database environment, said computer system comprising:
-
one or more computer processors; and one or more computer-readable storage media; wherein program instructions are stored on the computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising instructions to cause the at least one of the one or more computer processors to; define a checkpoint image of the primary node including a database structure and a plurality of database pages; create a replica database on a backup node by initiating a backup node and saving the defined database structure on the initiated backup node; send each database page of the checkpoint image to the backup node for saving; save, after creation of a checkpoint image is started, each subsequent transaction on the primary node thereby creating a corresponding REDO transaction for sending to the backup node; identify each data page operated on by each subsequent transaction; send, in parallel with the sending of the database pages, each created REDO transaction to the backup node in the order in which the corresponding transaction occurred so that the backup node can replicate the transactions in the correct order; and prioritize each identified database page so that it arrives at the backup node before or substantially at the same time as a corresponding REDO transaction whereby the corresponding REDO transaction can operate on the identified database page without waiting for every database page to be saved on the backup node. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method for replicating a database image of an operational primary node to a backup node in a distributed database environment, said method comprising:
-
defining a checkpoint image of a primary node including a database structure and a plurality of database pages; creating a replica database on a backup node by initiating a backup node and saving the defined database structure on the initiated backup node; sending each database page of the checkpoint image to the backup node for saving; saving, after creation of a checkpoint image is started, each subsequent transaction on the primary node thereby creating a corresponding REDO transaction for sending to the backup node; identifying each data page operated on by each subsequent transaction; sending, in parallel with the sending of the database pages, each created REDO transaction to the backup node in the order in which the corresponding transaction occurred so that the backup node can replicate the transactions in the correct order; and prioritizing each identified database page so that it arrives at the backup node before or substantially at the same time as a corresponding REDO transaction whereby the corresponding REDO transaction can operate on the identified database page without waiting for every database page to be saved on the backup node. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer program product for replicating a database image from an operational primary node to a backup node in a distributed database environment, the computer program product comprising a non-transitory computer-readable storage medium having computer-readable program code embodied therewith, the computer-readable program code configured to:
-
define a checkpoint image of a primary node including a database structure and a plurality of database pages; create a replica database on a backup node by initiating a backup node and saving the defined database structure on the initiated backup node; send each database page of the checkpoint image to the backup node for saving; save, after creation of a checkpoint image is started, each subsequent transaction on the primary node thereby creating a corresponding REDO transaction for sending to the backup node; identify each data page operated on by each subsequent transaction; send, in parallel with the sending of the database pages, each created REDO transaction to the backup node in the order in which the corresponding transaction occurred so that the backup node can replicate the transactions in the correct order; and prioritize each identified database page so that it arrives at the backup node before or substantially at the same time as a corresponding REDO transaction whereby the corresponding REDO transaction can operate on the identified database page without waiting for every database page to be saved on the backup node. - View Dependent Claims (18, 19, 20)
-
Specification