FACILITATING DATA MIGRATION BETWEEN DATABASE CLUSTERS WHILE THE DATABASE CONTINUES OPERATING
First Claim
1. A method, comprising:
- while a database continues to process live database traffic, performing the following operations;
recording a current position in an operation log for the database, wherein the operation log contains a sequential record of operations applied to the database;
retrieving data items from a source cluster in the database;
inserting the copies of the retrieved data items into a destination cluster in the database;
applying a sequence of updates, starting from the recorded position in the operation log, to the copies of the data items in the destination cluster; and
after the sequence of updates is applied, performing a cut-over operation that diverts the live database traffic from the data items on the source cluster to the copies of the data items on the destination cluster.
4 Assignments
0 Petitions
Accused Products
Abstract
A system for migrating data items from a source cluster to a destination cluster in a database system. During operation, while the database continues to process live database traffic, the system records a current position in an operation log for the database, wherein the operation log comprises a sequential record of operations applied to the database. Next, the system retrieves data items from the source cluster, and inserts the copies of the retrieved data items into the destination cluster. The system also applies a sequence of updates, starting from the recorded position in the operation log, to the copies of the data items in the destination cluster. Finally, after the sequence of updates is applied, the system performs a cut-over operation that diverts the live database traffic from the data items on the source cluster to the copies of the data items on the destination cluster.
-
Citations
20 Claims
-
1. A method, comprising:
while a database continues to process live database traffic, performing the following operations; recording a current position in an operation log for the database, wherein the operation log contains a sequential record of operations applied to the database; retrieving data items from a source cluster in the database; inserting the copies of the retrieved data items into a destination cluster in the database; applying a sequence of updates, starting from the recorded position in the operation log, to the copies of the data items in the destination cluster; and after the sequence of updates is applied, performing a cut-over operation that diverts the live database traffic from the data items on the source cluster to the copies of the data items on the destination cluster. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
9. A system, comprising:
-
a database server within a database; and a migration module within the database server, wherein the migration module includes a memory storing instructions for controlling a processor to perform a migration operation, the migration operation comprising; while the database continues to process live database traffic performing the following operations; recording a current position in an operation log for the database, wherein the operation log contains a sequential record of operations applied to the database; retrieving data items from a source cluster in the database; inserting the copies of the retrieved data items into a destination cluster in the database; applying a sequence of updates, starting from the recorded position in the operation log, to the copies of the data items in the destination cluster; and after the sequence of updates is applied, performing a cut-over operation that diverts the live database traffic from the data items on the source cluster to the copies of the data items on the destination cluster. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A non-transitory computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method, comprising:
while a database continues to process live database traffic, performing the following operations; recording a current position in an operation log for the database, wherein the operation log contains a sequential record of operations applied to the database; retrieving data items from a source cluster in the database; inserting the copies of the retrieved data items into a destination cluster in the database; applying a sequence of updates, starting from the recorded position in the operation log, to the copies of the data items in the destination cluster; and after the sequence of updates is applied, performing a cut-over operation that diverts the live database traffic from the data items on the source cluster to the copies of the data items on the destination cluster. - View Dependent Claims (16, 17, 18, 19, 20)
Specification