Protecting a management database of a data storage management system to meet a recovery point objective (RPO)

Patent metadata

Field	Value
Publication number	US-12045145-B2
Application number	US-202318451940-A
Country	US
Kind code	B2
Filing date	Aug 18, 2023
Priority date	Feb 9, 2022
Publication date	Jul 23, 2024
Grant date	Jul 23, 2024

Abstract

An illustrative data storage management system comprises a management database that stores administrative preferences and system configurations, as well as results and/or statistics of completed secondary storage operations, i.e., information needed by the system to protect customers' data and to track and recover the protected data, including secondary copies such as backup copies, archive copies, etc. The disclosed data storage management system is configured to protect its own system data subject to a very aggressive (short) Recovery Point Objective (RPO), by using an innovative infrastructure that enables the system's storage manager to fail over to any number of other failover destination storage managers, each one comprising a destination management database. An illustrative database granularly tracks whether each and every transaction log file has been successfully applied to each and every destination management database to synchronize with the source management database.

First claim

What is claimed is:

1. A system comprising:
a first computing device; and
a second computing device in communication with first data storage resources;
wherein the first computing device is configured to:
host a storage manager that manages storage operations in the system,
populate a first database of a first database management system, wherein the first database comprises information about one or more of: the storage operations, and preferences associated with performing the storage operations,
at a first time frequency that is based on a recovery point objective (RPO) for the first database, cause the first database management system to write a first plurality of transaction log files to a data path at the first data storage resources,
wherein the first plurality of transaction log files correspond to changes in the first database that occurred since a preceding writing of transaction log files to the data path, by the first database management system;
wherein the second computing device is configured to, at a second time frequency that is longer than the first time frequency, perform a first storage operation that:
generates backup data chunks from a set of transaction log files that are stored at the first data storage resources in a native format as issued by the first database management system, wherein the set of transaction log files includes the first plurality of transaction log files, and wherein the backup data chunks are in a backup format that is different from the native format, and
stores the backup data chunks at one or more of: the first data storage resources, and second data storage resources that are distinct from the first data storage resources;
wherein each of: the first computing device, and the second computing device comprises one or more hardware processors.

2. The system of claim 1 , wherein a first destination computing device, among a plurality of destination computing devices, is configured to: host a storage manager that initiates a second storage operation, which causes the backup data chunks to be restored to a second database of a second database management system;
wherein each of the plurality of destination computing devices comprises one or more hardware processors; and
wherein the second computing device is further configured to: track whether, for each transaction log file at the first data storage resources, one or more corresponding backup data chunks have been successfully restored to a respective second database populated by each destination computing device among the plurality of destination computing devices.

3. The system of claim 2 , wherein each destination computing device is configured to initiate the second storage operation independently of whether another destination computing device among the plurality of destination computing devices has initiated a respective second storage operation.

4. The system of claim 2 , wherein the first destination computing device is further configured to:
after the second storage operation successfully restored one or more backup data chunks that correspond to a given transaction log file to the second database populated by the first destination computing device, indicate, in a third database populated by the second computing device, that the given transaction log file has been synchronized to one or more of: the first destination computing device, and the second database populated by the first destination computing device.

5. The system of claim 4 , wherein the first destination computing device is further configured to:
execute a data agent that is in communication with a second database management system, at the first destination computing device, and
wherein the data agent is configured to, as part of the second storage operation, transmit each restored backup data chunk to the second database management system with instructions to apply the restored backup data chunk to the second database.

6. The system of claim 2 , wherein the second computing device is further configured to: execute a media agent that:
transforms the set of transaction log files from the native format to the backup data chunks in the backup format, and
performs the second storage operation, in conjunction with a data agent that executes at the first destination computing device, to restore the backup data chunks.

7. The system of claim 6 , wherein the data agent is in communication with a second database management system, and
wherein the data agent is configured to, as part of the second storage operation, transmit each restored backup data chunk to a second database management system at the first destination computing device with instructions to apply the restored backup data chunk to the second database.

8. The system of claim 1 , wherein the RPO is configured as a preference for the system, and wherein the first time frequency is shorter than performing a backup of the first database.

9. The system of claim 1 , wherein whether or not the RPO is met is based on when the first plurality of transaction log files are stored at the first data storage resources compared to the first time frequency.

10. The system of claim 1 , wherein a first data agent, which is hosted by the first computing device and is associated with the first database management system, is configured to cause the first database management system to write the first plurality of transaction log files to the data path at the first data storage resources.

11. The system of claim 1 , wherein a first data agent, which is hosted by the first computing device and is associated with the first database management system, is configured to cause the first database management system to write the first plurality of transaction log files to the data path at the first data storage resources via a media agent that is hosted by the second computing device.

12. A system comprising:
a first computing device;
a second computing device in communication with first data storage resources; and
at least one destination computing device;
wherein the first computing device is configured to:
host a storage manager that manages storage operations in the system,
populate a first database of a first database management system, wherein the first database comprises information about one or more of: the storage operations, and preferences associated with performing the storage operations,
at a second time after a first time, cause the first database management system to write a first plurality of transaction log files to a data path at the first data storage resources,
wherein the first plurality of transaction log files correspond to changes in the first database that occurred at or after the first time, and
wherein transaction log files, including the first plurality of transaction log files, are written to the first data storage resources at a time frequency that is based on a recovery point objective (RPO) for the first database;
wherein the second computing device is configured to, at a time frequency that is longer than the RPO, perform a first storage operation that:
generates backup data chunks from a set of transaction log files that are stored at the first data storage resources in a native format as issued by the first database management system, wherein the set of transaction log files includes the first plurality of transaction log files, and wherein the backup data chunks are in a backup format that is different from the native format, and
stores the backup data chunks at one or more of: the first data storage resources, and second data storage resources that are distinct from the first data storage resources;
wherein a first destin

Assignees

• Commvault Systems Inc

Inventors

• Bhagi Sri Karthik
• Sabjan Check Abdoul Cader
• Ahn Jun H

Classifications

• G06F11/1474

  in transactions (updating of structured data in databases G06F16/23) · CPC title

• G06F2201/87

  Monitoring of transactions · CPC title

• G06F11/1471

  involving logging of persistent data for recovery · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1469 Primary

  Backup restoration techniques · CPC title