Integration of database with distributed storage system
Techniques are described for determining whether a backup chain is within a recoverable range. The recoverable range defines a time interval in which data from a database system is recoverable to a point in time within the time interval. The backup chain is preserved while the backup chain is within the recoverable range. Upon determining that the backup chain is not within the recoverable range, operations are described for checking a retention policy for the backup chain, determining whether to preserve or expire the backup chain based on the retention policy, and preserving the backup chain based on that determination.
1. A method, comprising:
generating, by a second system that is configured to protect data associated with a database system, a backup chain comprising a full backup of the database system and one or more incremental backups of the database system that depend on the full backup;
determining that the full backup from the backup chain is outside a recoverable range and that at least one incremental backup from the backup chain is within the recoverable range, the recoverable range defining a time interval in which data from the database system is recoverable to a point in time within the time interval;
retaining, in storage, the full backup that is outside the recoverable range based at least in part on the at least one incremental backup being within the recoverable range;
determining, after the at least one incremental backup and the full backup have been retained in storage for a time period, that all of the one or more incremental backups are outside the recoverable range; and
deleting the backup chain from storage in accordance with a retention policy for the backup chain upon determining that all of the one or more incremental backups are outside the recoverable range.
2. The method as recited in claim 1 , further comprising:
presenting the recoverable range within a user interface (UI), the recoverable range being presented as a line or an area within a calendar.
3. The method as recited in claim 1 , wherein the backup chain is for storing data from the database system in the second system.
4. The method as recited in claim 3 , further comprising:
installing a backup agent at a host associated with the database system, the backup agent interacting with the second system to execute commands on the host associated with the database system.
5. The method as recited in claim 3 , further comprising:
upon determining that a first backup is being purged from the second system, sending a request, by the second system, to delete data associated with the first backup from the database system.
6. The method as recited in claim 3 , wherein the second system provides service level agreement (SLA) compliance to store the data from the database system.
7. The method as recited in claim 6 , further comprising:
causing presentation of a UI for configuring the SLA.
8. The method as recited in claim 1 , wherein the retention policy defines a period of time for keeping backups in the backup chain before purge.
9. A system, comprising:
at least one memory comprising instructions; and
one or more computer processors, wherein the instructions are executable by the one or more computer processors to cause the system to perform operations comprising:
generating, by a second system that is configured to protect data associated with a database system, a backup chain comprising a full backup of the database system and one or more incremental backups of the database system that depend on the full backup;
determining that the full backup from the backup chain is outside a recoverable range and that at least one incremental backup from the backup chain is within the recoverable range, the recoverable range defining a time interval in which data from the database system is recoverable to a point in time within the time interval;
retaining, in storage, the full backup that is outside the recoverable range based at least in part on the at least one incremental backup being within the recoverable range;
determining, after the at least one incremental backup and the full backup have been retained in storage for a time period, that all of the one or more incremental backups are outside the recoverable range; and
deleting the backup chain from storage in accordance with a retention policy for the backup chain upon determining that all of the one or more incremental backups are outside the recoverable range.
10. The system as recited in claim 9 , wherein the instructions further cause the one or more computer processors to perform operations comprising:
presenting the recoverable range within a user interface (UI), the recoverable range being presented as a line or an area within a calendar.
11. The system as recited in claim 9 , wherein the backup chain is for storing data from the database system in the second system, and wherein the instructions further cause the one or more computer processors to perform operations comprising:
installing a backup agent at a host associated with the database system, the backup agent interacting with the second system to execute commands on the host associated with the database system.
12. A tangible machine-readable storage medium including instructions that are executable by a machine to cause the machine to perform operations comprising:
generating, by a second system that is configured to protect data associated with a database system, a backup chain comprising a full backup of the database system and one or more incremental backups of the database system that depend on the full backup;
determining that the full backup from the backup chain is outside a recoverable range and that at least one incremental backup from the backup chain is within the recoverable range, the recoverable range defining a time interval in which data from the database system is recoverable to a point in time within the time interval;
retaining, in storage, the full backup that is outside the recoverable range based at least in part on the at least one incremental backup being within the recoverable range;
determining, after the at least one incremental backup and the full backup have been retained in storage for a time period, that all of the one or more incremental backups are outside the recoverable range; and
deleting the backup chain from storage in accordance with a retention policy for the backup chain upon determining that all of the one or more incremental backups are outside the recoverable range.
13. The tangible machine-readable storage medium as recited in claim 12 , wherein the machine further performs operations comprising:
presenting the recoverable range within a user interface (UI), the recoverable range being presented as a line or an area within a calendar.
14. The tangible machine-readable storage medium as recited in claim 12 , wherein the backup chain is for storing data from the database system in the second system, wherein the machine further performs operations comprising:
installing a backup agent at a host associated with the database system, the backup agent interacting with the second system to execute commands on the host associated with the database system.