Performance metric-based selection of one or more database server instances to perform database recovery
First Claim
1. A method of selecting one or more database server instances to perform database recovery, the method comprising:
- determining, for each database server instance on each node of a plurality of nodes in a cluster, one or more performance metrics;
selecting, based on the one or more performance metrics for each database server instance, one or more particular database server instances to perform database recovery; and
the one or more articular database server instances performing said database recovery relative to data blocks that were present in a cache of a failed node of a relational database system;
wherein said selecting comprising selecting the one or more particular database server instances to perform, relative to the data blocks, steps comprising;
(a) replaying lost modifications the data blocks, followed by(b) undoing, relative to the data blocks relative to which the lost modifications were replayed, modifications that were not committed; and
wherein the method is performed by one or more computing devices.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and apparatus for selecting one or more instances to perform database recovery is provided. According to one aspect, one or more performance metrics are determined for each instance on each node in a cluster. Based on these performance metrics, which may be weighted to give one or more metrics more significance relative to the other metrics, an overall score is determined for each instance on each surviving node when a node in the cluster fails. One or more instances with the highest of these scores are selected. The selected instances are assigned the task of performing the database recovery process. Because instances best able to handle to database recovery process are selected, the database recovery process consumes less time, thereby making data accessible in less time after a node fails.
-
Citations
18 Claims
-
1. A method of selecting one or more database server instances to perform database recovery, the method comprising:
-
determining, for each database server instance on each node of a plurality of nodes in a cluster, one or more performance metrics; selecting, based on the one or more performance metrics for each database server instance, one or more particular database server instances to perform database recovery; and the one or more articular database server instances performing said database recovery relative to data blocks that were present in a cache of a failed node of a relational database system; wherein said selecting comprising selecting the one or more particular database server instances to perform, relative to the data blocks, steps comprising; (a) replaying lost modifications the data blocks, followed by (b) undoing, relative to the data blocks relative to which the lost modifications were replayed, modifications that were not committed; and wherein the method is performed by one or more computing devices. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)
-
Specification