Failure recovery in a parallel-processing database system
First Claim
1. In a parallel-processing based database management system having a plurality of interconnected processing nodes, a method for recovering from a failure of a processing node, the method comprising:
- storing, prior to failure of a first processing node, a database portion of the first processing node on a second processing node of the plurality of processing nodes;
replacing the first processing node with a third processing node of the plurality of processing nodes when the first processing node fails;
copying the database portion from the second processing node to the third processing node between database operations performed by the second processing node and the third processing node;
performing, by the third processing node, database operations using the database portion stored on the second processing node until the copying of the database portion from the second processing node to the third processing node is completed; and
performing, by the third processing node, database operations using the database portion stored at the third processing node when the copying of the database portion from the second processing node to the third processing node is completed.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and method for failure recovery in a multiple processing node system are described herein. Each node can be adapted to store a backup copy of its database portion and/or results to disk storage or memory of at least one other node. In the event of a failure of a node, the replacement node can be adapted to transfer or copy the backup copy of the database portion of the failed node from the failed node'"'"'s neighbors to the replacement node'"'"'s disk storage or memory in between database operations. Before the transfer or copy of the backup copy is completed, the replacement node can be adapted to perform database operations in part on the portion of the backup copy the replacement node has already received and in part on the backup copy stored at the neighboring node(s).
-
Citations
14 Claims
-
1. In a parallel-processing based database management system having a plurality of
interconnected processing nodes, a method for recovering from a failure of a processing node, the method comprising: -
storing, prior to failure of a first processing node, a database portion of the first processing node on a second processing node of the plurality of processing nodes;
replacing the first processing node with a third processing node of the plurality of processing nodes when the first processing node fails;
copying the database portion from the second processing node to the third processing node between database operations performed by the second processing node and the third processing node;
performing, by the third processing node, database operations using the database portion stored on the second processing node until the copying of the database portion from the second processing node to the third processing node is completed; and
performing, by the third processing node, database operations using the database portion stored at the third processing node when the copying of the database portion from the second processing node to the third processing node is completed. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. In a parallel-processing based database management system, a system for failover recovery comprising:
-
a first processing node storing a first database portion and being adapted to perform at least one database operation on the first database portion;
a second processing node operably connected to the first processing node and storing a second database portion and being adapted to perform the at least one database operation on the second database portion, and wherein prior to a failure of the first processing node, the first database portion is stored on the second processing node; and
a third processing node operably connected to the second processing node and being adapted to;
perform at least one database operation using the first database portion after the first processing node fails; and
copy the first database portion from the second node between database operations performed by the second processing node and the third processing node;
wherein the third processing node performs database operations using the first database portion stored on the second processing node until the copying of the first database portion from the second processing node to the third processing node is completed; and
wherein the third processing node performs database operations using the first database portion stored at the third processing node when the copying of the first database portion from the second processing node to the third processing node is completed. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
Specification