Allocation of cloud-based resources for backup/recovery services
Disclosed is an improved system, method, and computer program product to allocate backup devices for a database system, where an appropriate appliance can be automatically allocated to accommodate backups. The allocation selects an appliance that effectively balances space allocation needs of the database with overall performance effects on a multi-tenant backup system that handles multiple databases of varying sizes.
1. A method, comprising:
maintaining a plurality of devices to store backup data for database systems;
identifying a database to back up to the plurality of devices;
determining a space requirement for backing up the database,
comparing the space requirement to a database size threshold;
allocating, when the space requirement is larger than the database size threshold, the database to a first device having a greatest amount of free space from among the plurality of devices; and
allocating, when the space requirement is smaller than the database size threshold, the database to a second device having a smallest amount of free space from among the plurality of devices that at least includes enough of the free space to meet the space requirement for backing up the database.
2. The method of claim 1 , wherein the plurality of devices is maintained as a cloud-based service for providing recovery and backup services to users, the plurality of devices being shared by multiple users.
3. The method of claim 1 , wherein the space requirement for backing up the database is determined based upon a database size combined with a database growth value based at least in part upon a change rate and an archival size correlated to a recovery window size.
4. The method of claim 3 , wherein the recovery window size is based upon a protection policy that is established for the database.
5. The method of claim 1 , wherein the database size threshold is adjusted to a higher value to increase data packing onto the plurality of devices.
6. The method of claim 1 , wherein the database size threshold is adjusted to a smaller value to increase data spreading across the plurality of devices.
7. The method of claim 1 , wherein a learning model is utilized to determine whether to modify the database size threshold.
8. A system for backing up a database in a database system, comprising:
a processor;
a memory for holding programmable code; and
wherein the programmable code includes instructions for identifying a database to back up to a plurality of devices; determining a space requirement for backing up the database, comparing the space requirement to a database size threshold; allocating, when the space requirement is larger than the database size threshold, the database to a first device having a greatest amount of free space from among the plurality of devices; and allocating, when the space requirement is smaller than the database size threshold, the database to a second device having a smallest amount of free space from among the plurality of devices that at least includes enough of the free space to meet the space requirement for backing up the database.
9. The system of claim 8 , wherein the plurality of devices is maintained as a cloud-based service for providing recovery and backup services to users, the plurality of devices being shared by multiple users.
10. The system of claim 8 , wherein the space requirement for backing up the database is determined based upon a database size combined with a database growth value based at least in part upon a change rate and an archival size correlated to a recovery window size.
11. The system of claim 10 , wherein the recovery window size is based upon a protection policy that is established for the database.
12. The system of claim 8 , wherein the database size threshold is adjusted to a higher value to increase data packing onto the plurality of devices.
13. The system of claim 8 , wherein the database size threshold is adjusted to a smaller value to increase data spreading across the plurality of devices.
14. The system of claim 8 , wherein a learning model is utilized to determine whether to modify the database size threshold.
15. A computer program product embodied on a computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor, executes a method comprising:
maintaining a plurality of devices to store backup data for database systems;
identifying a database to back up to the plurality of devices;
determining a space requirement for backing up the database,
comparing the space requirement to a database size threshold;
allocating, when the space requirement is larger than the database size threshold, the database to a first device having a greatest amount of free space from among the plurality of devices; and
allocating, when the space requirement is smaller than the database size threshold, the database to a second device having a smallest amount of free space from among the plurality of devices that at least includes enough of the free space to meet the space requirement for backing up the database.
16. The computer program product of claim 15 , wherein the plurality of devices is maintained as a cloud-based service for providing recovery and backup services to users, the plurality of devices being shared by multiple users.
17. The computer program product of claim 15 , wherein the space requirement for backing up the database is determined based upon a database size combined with a database growth value based at least in part upon a change rate and an archival size correlated to a recovery window size.
18. The computer program product of claim 17 , wherein the recovery window size is based upon a protection policy that is established for the database.
19. The computer program product of claim 15 , wherein the database size threshold is adjusted to a higher value to increase data packing onto the plurality of devices.
20. The computer program product of claim 15 , wherein the database size threshold is adjusted to a smaller value to increase data spreading across the plurality of devices.
21. The computer program product of claim 15 , wherein a learning model is utilized to determine whether to modify the database size threshold.