Speculative recovery using storage snapshot in a clustered database
A system, and computer program product for recovery in a database are provided in the illustrative embodiments. A failure is detected in a first computing node, the first computing node serving the database in a cluster of computing nodes. A snapshot is created of data of the database. A subset of log entries is applied to the snapshot, the applying modifying the snapshot to result in a modified snapshot. An access of the first computing node to the data of the database is preserved. Responsive to receiving a signal of activity from the first computing node during the applying and after a grace period has elapsed, the applying is aborted such that the first computing node can continue serving the database in the cluster.
1. A computer usable program product comprising a computer usable storage device including computer usable code for recovery in a database, the computer usable code comprising:
computer usable code for detecting a failure in a first computing node, the first computing node serving the database in a cluster of computing nodes;
computer usable code for creating, using a processor and a memory, a snapshot of data of the database;
computer usable code for applying, using the processor and the memory, a subset of log entries to the snapshot, the applying modifying the snapshot to result in a modified snapshot;
computer usable code for preserving an access of the first computing node to the data of the database; and
computer usable code for aborting, responsive to receiving a signal of activity from the first computing node during the applying and after a grace period has elapsed, the applying such that the first computing node can continue serving the database in the cluster.
2. The computer usable program product of claim 1 , further comprising:
computer usable code for receiving the signal of activity from the first computing node during the applying and after the grace period for the signal of activity has elapsed;
computer usable code for determining a level of performance of the first computing node;
computer usable code for completing the applying responsive to the level of performance begin below a threshold; and
computer usable code for taking over the serving of the database from the first computing node using the snapshot such that the first computing node cannot serve the database in the cluster.
3. The computer usable program product of claim 2 , further comprising:
computer usable code for combining the modified snapshot with a modified data of the database, wherein the modified data of the database results from the first computing node continuing to modify the data of the database after the creating of the snapshot.
4. The computer usable program product of claim 3 , wherein the combining comprises a reverse copy operation.
5. The computer usable program product of claim 1 , wherein the computer usable code is stored in a computer readable storage device in a data processing system, and wherein the computer usable code is transferred over a network from a remote data processing system.
6. The computer usable program product of claim 1 , wherein the computer usable code is stored in a computer readable storage device in a server data processing system, and wherein the computer usable code is downloaded over a network to a remote data processing system for use in a computer readable storage device associated with the remote data processing system.
7. A data processing system for recovery in a database, the data processing system comprising:
a storage device, wherein the storage device stores computer usable program code; and
a processor, wherein the processor executes the computer usable program code, and wherein the computer usable program code comprises:
computer usable code for detecting a failure in a first computing node, the first computing node serving the database in a cluster of computing nodes;
computer usable code for creating, using a processor and a memory, a snapshot of data of the database;
computer usable code for applying, using the processor and the memory, a subset of log entries to the snapshot, the applying modifying the snapshot to result in a modified snapshot;
computer usable code for preserving an access of the first computing node to the data of the database; and
computer usable code for aborting, responsive to receiving a signal of activity from the first computing node during the applying and after a grace period has elapsed, the applying such that the first computing node can continue serving the database in the cluster.