DATABASE SYSTEM WITH ACTIVE STANDBY AND NODES
First Claim
1. A database system comprising:
- an active node enabled toreceive database updates,apply the database updates to a respective database, andwrite-through the database updates as corresponding active write-through updates;
a standby node enabled toreceive the active write-through updates,apply the active write-through updates to a respective database, andwrite-through the active write-through updates as corresponding standby write-through updates to a primary database; and
wherein the respective database of the standby node contains a subset of the database updates as compared to the respective database of the active node, and the primary database contains a subset of the database updates as compared to the respective database of the standby node.
1 Assignment
0 Petitions
Accused Products
Abstract
A system includes an active node and a standby node and zero or more replica nodes. Each of the nodes includes a database system, such as an in-memory database system. Client updates applied to the active node are written through to the standby node, and the standby node writes the updates through to a primary database and updates the replica nodes. Commit ticket numbers tag entries in transaction logs and are used to facilitate recovery if either of the active node or the standby node fails. Updates applied to the primary database are autorefreshed to the active node and written through by the active node to the standby node which propagates the updates to the replica nodes. Bookmarks are used to track updated records of the primary database and are used to facilitate recovery if either of the active node or the standby node fails.
197 Citations
27 Claims
-
1. A database system comprising:
-
an active node enabled to receive database updates, apply the database updates to a respective database, and write-through the database updates as corresponding active write-through updates; a standby node enabled to receive the active write-through updates, apply the active write-through updates to a respective database, and write-through the active write-through updates as corresponding standby write-through updates to a primary database; and wherein the respective database of the standby node contains a subset of the database updates as compared to the respective database of the active node, and the primary database contains a subset of the database updates as compared to the respective database of the standby node. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method for recovering from failure of a first secondary database, the method comprising:
-
at the first secondary database, receiving database updates and writing through the database updates as corresponding active write-through updates; at a second secondary database, receiving the active write-through updates and writing through the active write-through updates as corresponding standby write-through updates to a primary database; detecting a failure of the first secondary database; changing status of the second secondary database to active; and subsequent to the changing status, receiving the database updates at the second secondary database. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A method comprising:
-
determining respective keys and respective corresponding bookmark numbers of rows of a change log that have the respective bookmark number sequentially after a last-applied bookmark number; updating rows of one or more tables of an active secondary database with rows of corresponding tables of a primary database, the rows of the corresponding tables of the primary database having the determined keys; and writing through the updates of the rows of the tables of the active secondary database to a standby secondary database the written-through updates comprising, for each of the rows of the tables of the active secondary database, the corresponding bookmark number of the determined key of the row. - View Dependent Claims (21, 22, 23)
-
-
24. A computer-readable medium having a set of instructions stored therein which when executed by a processing device causes the processing device to perform procedures comprising:
-
receiving, from a first node, a database update, wherein the database update comprises a master update list locator, the master update list locator associated with at least one of a plurality of entries of a master update list of the first node, the at least one entry associated with application of the database update to a respective database of the first node; applying the database update to a secondary database; recording, in a particular one of a plurality of entries of a local update list, information associated with the applying, and wherein a local update list locator is associated with the particular entry; and writing through the database update to a second node, and wherein the written-through update comprises the master update list locator and the local update list locator. - View Dependent Claims (25, 26, 27)
-
Specification