Automatic backup strategy selection
A system and method to receive, from a database service executing on a cloud infrastructure, information indicating metrics regarding backups for the database service, the information including at least an indication of an age of a last complete backup for the database service, an indication of a size of changed data since the last complete backup, and an indication of a number of data units changed since the last complete backup; determine a type of backup strategy to instruct the database service to perform based on the received information, the type of backup strategy being one of a complete backup of the database service, a delta backup of the database service, and no backup of the database service; and issue, in response to the determination, an instruction to the database service to execute the determined type of backup.
1. A system comprising:
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the system to:
receive, from a database service executing on a cloud infrastructure, information indicating metrics regarding backups for the database service;
determine, based on an analysis of a combination of the received information, a type of backup strategy to instruct the database service to perform, the analysis including:
determine, based on an indication of an age of a last complete backup for the database service, whether to instruct the database service to perform a complete backup of the database service, where a complete backup of the database service is instructed in an instance the age of the last complete backup is greater than a first threshold;
in an instance the age of the last complete backup is not greater than the first threshold, determine, based on a ratio of a total data size of a database of the database service and a size of changed data since the last complete backup, whether to instruct the database service to perform a delta backup of the database service, where a delta backup of the database service is instructed in an instance the ratio is less than a second threshold; and
in an instance the ratio is greater than the second threshold, determine, based on an indication of a number of data units changed since the last complete backup, whether to instruct the database service to perform a complete backup of the database service or a delta backup of the database service, where a complete backup of the database service is instructed in an instance the number of data units changed since the last complete backup is greater than a third threshold value and a delta backup of the database service is instructed in an instance the number of data units changed since the last complete backup is less than the third threshold; and
issue, in response to the determinations, an instruction to the database service to execute the determined type of backup.
2. The system of claim 1 , wherein the processor is further configured to execute the processor-executable program code in order to cause the system to query the database service for the information indicating metrics regarding backups for the database service.
3. The system of claim 1 , wherein the determination of the type of backup strategy to instruct the database service to perform is executed in advance of an execution of a data backup of the database service.
4. The system of claim 1 , wherein the determination of the type of backup strategy to instruct the database service to perform is adjusted in response to a varying workload of the database service.
5. The system of claim 4 , wherein the system is a backup service that interfaces with the database service.
6. The system of claim 1 , wherein the information indicating metrics regarding backups for the database service query is representative of an actual state of the database service.
7. The system of claim 1 , wherein the determination of the type of backup strategy to instruct the database service to perform is further based on a time to complete a recovery process for the database service.
8. A computer-implemented method, the method comprising:
receiving, from a database service executing on a cloud infrastructure, information indicating metrics regarding backups for the database service;
determining, based on an analysis of a combination of the received information, a type of backup strategy to instruct the database service to perform, the analysis including:
determining, based on an indication of an age of a last complete backup for the database service, whether to instruct the database service to perform a complete backup of the database service, where a complete backup of the database service is instructed in an instance the age of the last complete backup is greater than a first threshold;
in an instance the age of the last complete backup is not greater than the first threshold, determining, based on a ratio of a total data size of a database of the database service and a size of changed data since the last complete backup, whether to instruct the database service to perform a delta backup of the database service, where a delta backup of the database service is instructed in an instance the ratio is less than a second threshold; and
in an instance the ratio is greater than the second threshold, determining, based on an indication of a number of data units changed since the last complete backup, whether to instruct the database service to perform a complete backup of the database service or a delta backup of the database service, where a complete backup of the database service is instructed in an instance the number of data units changed since the last complete backup is greater than a third threshold value and a delta backup of the database service is instructed in an instance the number of data units changed since the last complete backup is less than the third threshold; and
issuing, in response to the determination, an instruction to the database service to execute the determined type Of backup.
9. The method of claim 8 , wherein the processor is further configured to execute the processor-executable program code in order to cause the system to query the database service for the information indicating metrics regarding backups for the database service.
10. The method of claim 8 , wherein the determination of the type of backup strategy to instruct the database service to perform is executed in advance of an execution of a data backup of the database service.
11. The method of claim 8 , wherein the determination of the type of backup strategy to instruct the database service to perform is adjusted in response to a varying workload of the database service.
12. The method of claim 8 , wherein the information indicating metrics regarding backups for the database service query is representative of an actual state of the database service.
13. The method of claim 8 , wherein the determination of the type of backup strategy to instruct the database service to perform is further based on a time to complete a recovery process for the database service.
14. A non-transitory, computer readable medium storing instructions, which when executed by at least one processor cause a computer to perform a method comprising:
receiving, from a database service executing on a cloud infrastructure, information indicating metrics regarding backups for the database service;
determining, based on an analysis of a combination of the received information, a type of backup strategy to instruct the database service to perform, the analysis including:
determining, based on an indication of an age of a last complete backup for the database service, whether to instruct the database service to perform a complete backup of the database service, where a complete backup of the database service is instructed in an instance the age of the last complete backup is greater than a first threshold;
in an instance the age of the last complete backup is not greater than the first threshold, determining, based on a ratio of a total data size of a database of the database service and a size of changed data since the last complete backup, whether to instruct the database service to perform a delta backup of the database service, where a delta backup of the database service is instructed in an instance the ratio is less than a second threshold; and
in an instance the ratio is greater than the second threshold, determining, based on an indication of a number of data units changed since the last complete backup, whether to instruct the database service to perform, where a complete backup of the database service is instructed in an instance the number of data units changed since the last complete backup is greater than a third threshold value and a delta backup of the database service is instructed in an instance the number of data units changed since the last complete backup is less than the third threshold; and
issuing, in response to the determination, an instruction to the database service to execute the determined type of backup.
15. The medium of claim 14 , wherein the processor is further configured to execute the processor-executable program code in order to cause the system to query the database service for the information indicating metrics regarding backups for the database service.
16. The medium of claim 14 , wherein the determination of the type of backup strategy to instruct the database service to perform is executed in advance of an execution of a data backup of the database service.
17. The medium of claim 14 , wherein the determination of the type of backup strategy to instruct the database service to perform is adjusted in response to a varying workload of the database service.
18. The medium of claim 14 , wherein the information indicating metrics regarding backups for the database service query is representative of an actual state of the database service.
19. The medium of claim 14 , wherein the determination of the type of backup strategy to instruct the database service to perform is further based on a time to complete a recovery process for the database service.