Invention Grant
- Patent Title: Replication for on-line hot-standby database
-
Application No.: US14655364Application Date: 2014-03-18
-
Publication No.: US09798792B2Publication Date: 2017-10-24
- Inventor: Kyosti M. Laiho , Jan P. Lindstrom , Jarmo Parkkinen , Vilho T. Raatikka
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Jay Wahlquist
- Priority: GB1311259.4 20130625
- International Application: PCT/EP2014/055431 WO 20140318
- International Announcement: WO2014/206581 WO 20141231
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

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.
Public/Granted literature
- US20150339366A1 REPLICATION FOR ON-LINE HOT-STANDBY DATABASE Public/Granted day:2015-11-26
Information query