Synchronization of plural databases in a database replication system
First Claim
Patent Images
1. A method for synchronizing a target database with a source database in a database replication system wherein the source database is on-line during the synchronization, the target database thus receiving replication data during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the method comprising:
- (a) sending successive blocks of data from the first node to the target database, each block of data having a key range, each block of data including one or more rows of data;
(b) posting the successively sent blocks of data to the target database;
(c) storing the total key range of the blocks of data received at the target database; and
(d) posting any replication data received at the target database only if the row of data, or a key range inclusive of the row of data, corresponding to the received data has been previously posted to the target database through the synchronizing process.
5 Assignments
0 Petitions
Accused Products
Abstract
A target database is synchronized with a source database in a database replication system. Key ranges of blocks of data to be replicated are used in the replication process. Also, synchronization occurs simultaneously with replication.
41 Citations
20 Claims
-
1. A method for synchronizing a target database with a source database in a database replication system wherein the source database is on-line during the synchronization, the target database thus receiving replication data during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the method comprising:
-
(a) sending successive blocks of data from the first node to the target database, each block of data having a key range, each block of data including one or more rows of data;
(b) posting the successively sent blocks of data to the target database;
(c) storing the total key range of the blocks of data received at the target database; and
(d) posting any replication data received at the target database only if the row of data, or a key range inclusive of the row of data, corresponding to the received data has been previously posted to the target database through the synchronizing process. - View Dependent Claims (2, 3, 4)
-
-
5. A method for synchronizing a target database with a source database and replicating the source database to the target database in a database replication system, wherein the source database is on-line during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the method comprising:
-
(a) replicating changes in the source database to the target database by sending a replication stream from the first node to the second node;
(b) sending successive blocks of data from the first node to the target database to synchronize or resynchronize the target database with the source database, each block of data including one or more rows of data;
(c) inserting the successively sent blocks of data into the replication stream at a point when the respective blocks of data are current or consistent in the source database; and
(d) posting the replication stream to the target database, the method thereby allowing synchronization or resynchronization to occur simultaneously with replication. - View Dependent Claims (6, 7, 8)
-
-
9. A method for synchronizing a target database with a source database and replicating the source database to the target database in a database replication system, wherein the source database is on-line during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the method comprising:
-
(a) replicating changes in the source database to the target database by sending a replication stream from the first node to the second node;
(b) sending successive blocks of data from the first node to the target database to synchronize or resynchronize the target database with the source database, each block of data including one or more rows of data, the successively sent blocks of data defining a loading stream; and
(c) posting the successively sent blocks of data into the target database when the replication stream is occurring slower than the loading stream, the method thereby allowing synchronization or resynchronization to occur simultaneously with replication. - View Dependent Claims (10)
-
-
11. An article of manufacture for synchronizing a target database with a source database in a database replication system wherein the source database is on-line during the synchronization, the target database thus receiving replication data during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the article of manufacture comprising a computer-readable medium holding computer-executable instructions for performing the steps of:
-
(a) sending successive blocks of data from the first node to the target database, each block of data having a key range, each block of data including one or more rows of data;
(b) posting the successively sent blocks of data to the target database;
(c) storing the total key range of the blocks of data received at the target database; and
(d) posting any replication data received at the target database only if the row of data, or a key range inclusive of the row of data, corresponding to the received data has been previously posted to the target database through the synchronizing process. - View Dependent Claims (12, 13, 14)
-
-
15. An article of manufacture for synchronizing a target database with a source database and replicating the source database to the target database in a database replication system, wherein the source database is on-line during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the article of manufacture comprising a computer-readable medium holding computer-executable instructions for performing the steps of:
-
(a) replicating changes in the source database to the target database by sending a replication stream from the first node to the second node;
(b) sending successive blocks of data from the first node to the target database to synchronize or resynchronize the target database with the source database, each block of data including one or more rows of data;
(c) inserting the successively sent blocks of data into the replication stream at a point when the respective blocks of data are current or consistent in the source database; and
(d) posting the replication stream to the target database, the method thereby allowing synchronization or resynchronization to occur simultaneously with replication. - View Dependent Claims (16, 17, 18)
-
-
19. An article of manufacture for synchronizing a target database with a source database and replicating the source database to the target database in a database replication system, wherein the source database is on-line during the synchronization, the source database being located at a first node of the system, and the target database being located at a second node of the system, the article of manufacture comprising a computer-readable medium holding computer-executable instructions for performing the steps of:
-
(a) replicating changes in the source database to the target database by sending a replication stream from the first node to the second node;
(b) sending successive blocks of data from the first node to the target database to synchronize or resynchronize the target database with the source database, each block of data including one or more rows of data, the successively sent blocks of data defining a loading stream; and
(c) posting the successively sent blocks of data into the target database when the replication stream is occurring slower than the loading stream, the method thereby allowing synchronization or resynchronization to occur simultaneously with replication. - View Dependent Claims (20)
-
Specification