Snapshot backups of cluster databases
A system identifies a storage device that stores a computer cluster's database and a storage device that stores the computer cluster's transaction logs. The system creates a snapshot of the storage device that stores the database and/or a snapshot of the storage device that stores the transaction logs. The system mounts at least one snapshot on any host that is accessible to the data management system's native interface. The system enables the native interface to catalog a database recovery name created for the database snapshot and/or a transaction log recovery name created for the transaction logs snapshot. The system enables recovery of the database and/or the transaction logs by storing a mapping from the database recovery name to a database backup identifier created for the database snapshot and/or a mapping from the transaction log recovery name to a transaction log backup identifier created for the transaction logs snapshot.
1. A system comprising:
one or more processors; and
a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to:
identify at least one of (1) a storage device that stores a database associated with a computer cluster or (2) a storage device that stores a plurality of transaction logs associated with the computer cluster;
create at least one of (1) a snapshot of the storage device that stores the database or (1) a snapshot of the storage device that stores the plurality of transaction logs;
mount, automatically, the at least one snapshot on a host in response to the creation of the at least one snapshot, the host being accessible to a native interface for a management system of the database;
transmit a prompt to the native interface, the prompt including instructions to catalog at least one of (1) a database recovery name created for the snapshot of the storage device that stores the database or (2) a transaction log recovery name created for the snapshot of the storage device that stores the plurality of transaction logs; and
store at least one of (1) a mapping from the database recovery name to a database backup identifier created for the snapshot of the storage device that stores the database or (2) a mapping from the transaction log recovery name to a transaction log backup identifier created for the snapshot of the storage device that stores the plurality of transaction logs, wherein storing the at least one mapping enables recovery of at least one of the database or the plurality of transaction logs.
2. The system of claim 1 , wherein identifying at least one of the storage device that stores the database or the storage device that stores the plurality of transaction logs comprises identifying a logical group that stores the database and a logical group that stores the plurality of transaction logs and then identifying at least one of a mapping of the logical group that stores the database to the storage device that stores the database or a mapping of the logical group that stores the plurality of transaction logs to the storage device that stores the plurality of transaction logs.
3. The system of claim 1 , wherein creating at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs comprises quiescing the database before creating the snapshot of the storage device that stores the database and then un-quiescing the database after creating the snapshot of the storage device that stores the database.
4. The system of claim 1 , wherein creating at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs comprises copying at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs to a remote storage.
5. The system of claim 1 , wherein the processor-based application further causes the processor to:
identify at least one of any database recovery name or any transaction log recovery name selected by the native interface;
use at least one mapping to identify at least one snapshot corresponding to the at least one selection by the native interface;
rename the at least one snapshot with at least one of any database recovery name or any transaction log recovery name selected by the native interface;
mount the at least one snapshot to a host, the host being accessible to the native interface, wherein
the native interface to recovers at least one of any database or any plurality of transaction logs stored on the at least one storage device.
6. The system of claim 5 , wherein the processor-based application further causes the processor to enable the native interface to recover any plurality of transaction logs from the computer cluster.
7. The system of claim 1 , wherein the processor-based application further causes the processor to unmount the at least one snapshot.
8. A method comprising:
identifying at least one of (1) a storage device that stores a database associated with a computer cluster or (2) a storage device that stores a plurality of transaction logs associated with the computer cluster;
creating at least one of (1) a snapshot of the storage device that stores the database or (1) a snapshot of the storage device that stores the plurality of transaction logs;
mounting, automatically, the at least one snapshot on a host in response to the creation of the at least one snapshot, the host being accessible to a native interface for a management system of the database;
transmitting a prompt to the native interface, the prompt including instructions to catalog at least one of (1) a database recovery name created for the snapshot of the storage device that stores the database or (2) a transaction log recovery name created for the snapshot of the storage device that stores the plurality of transaction logs; and
storing at least one of (1) a mapping from the database recovery name to a database backup identifier created for the snapshot of the storage device that stores the database or (2) a mapping from the transaction log recovery name to a transaction log backup identifier created for the snapshot of the storage device that stores the plurality of transaction logs, wherein storing the at least one mapping enables recovery of at least one of the database or the plurality of transaction logs.
9. The method of claim 8 , wherein identifying at least one of the storage device that stores the database or the storage device that stores the plurality of transaction logs comprises identifying a logical group that stores the database and a logical group that stores the plurality of transaction logs and then identifying at least one of a mapping of the logical group that stores the database to the storage device that stores the database or a mapping of the logical group that stores the plurality of transaction logs to the storage device that stores the plurality of transaction logs.
10. The method of claim 8 , wherein creating at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs comprises quiescing the database before creating the snapshot of the storage device that stores the database and then un-quiescing the database after creating the snapshot of the storage device that stores the database.
11. The method of claim 8 , wherein creating at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs comprises copying at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs to a remote storage.
12. The method of claim 8 , wherein the method further comprises:
identifying at least one of (1) any database recovery name or (2) any transaction log recovery name selected by the native interface;
using at least one mapping to identify at least one snapshot corresponding to the at least one selection by the native interface;
renaming the at least one snapshot with at least one of any database recovery name or any transaction log recovery name selected by the native interface;
mounting the at least one snapshot to a host, the host being accessible to the native interface, wherein
the native interface to recovers at least one of any database or any plurality of transaction logs stored on the at least one storage device.
13. The method of claim 12 , wherein the method further comprises:
enabling the native interface to recover any plurality of transaction logs from the computer cluster; and
unmounting the at least one snapshot.
14. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein to be executed by one or more processors, the program code including instructions to:
identify at least one of (1) a storage device that stores a database associated with a computer cluster or (2) a storage device that stores a plurality of transaction logs associated with the computer cluster;
create at least one of (1) a snapshot of the storage device that stores the database or (1) a snapshot of the storage device that stores the plurality of transaction logs;
mount, automatically, the at least one snapshot on a host in response to the creation of the at least one snapshot, the host being accessible to a native interface for a management system of the database;
transmit a prompt to the native interface, the prompt including instructions to catalog at least one of (1) a database recovery name created for the snapshot of the storage device that stores the database or (2) a transaction log recovery name created for the snapshot of the storage device that stores the plurality of transaction logs; and
store at least one of (1) a mapping from the database recovery name to a database backup identifier created for the snapshot of the storage device that stores the database or (2) a mapping from the transaction log recovery name to a transaction log backup identifier created for the snapshot of the storage device that stores the plurality of transaction logs, wherein storing the at least one mapping enables recovery of at least one of the database or the plurality of transaction logs.
15. The computer program product of claim 14 , wherein identifying at least one of the storage device that stores the database or the storage device that stores the plurality of transaction logs comprises identifying a logical group that stores the database and a logical group that stores the plurality of transaction logs and then identifying at least one of a mapping of the logical group that stores the database to the storage device that stores the database or a mapping of the logical group that stores the plurality of transaction logs to the storage device that stores the plurality of transaction logs.
16. The computer program product of claim 14 , wherein creating at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs comprises quiescing the database before creating the snapshot of the storage device that stores the database and then un-quiescing the database after creating the snapshot of the storage device that stores the database.
17. The computer program product of claim 14 , wherein creating at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs comprises copying at least one of the snapshot of the storage device that stores the database or the snapshot of the storage device that stores the plurality of transaction logs to a remote storage.
18. The computer program product of claim 14 , wherein the program code includes further instructions to:
identify at least one of (1) any database recovery name or (2) any transaction log recovery name selected by the native interface;
use at least one mapping to identify at least one snapshot corresponding to the at least one selection by the native interface;
rename the at least one snapshot with at least one of (1) any database recovery name or (2) any transaction log recovery name selected by the native interface;
mount the at least one snapshot to a host, the host being accessible to the native interface, wherein
the native interface to recovers at least one of any database or any plurality of transaction logs stored on the at least one storage device.
19. The computer program product of claim 14 , wherein the program code includes further instructions to enable the native interface to recover any plurality of transaction logs from the computer cluster.
20. The computer program product of claim 14 , wherein the program code includes further instructions to unmount the at least one snapshot.