Automatic backup distribution for clustered databases

An apparatus, comprising:

• at least one processor;
• at least one memory coupled with the at least one processor;
• and
• instructions stored in the at least one memory and executable by the at least one processor to cause the apparatus to:
• receive, from a user of a data management platform, a first job request to perform a backup of data from a data source to a database managed by the user of the data management platform, wherein the database is configured as a plurality of database instances running on a plurality of computing nodes of a computing cluster;
• store, in a metadata file, a backup load indication that indicates which computing node of the plurality of computing nodes is assigned to perform the backup of the data based at least in part on receiving the first job request, wherein the metadata file is configured to store a plurality of backup load indications for the database and a set of load balancing metrics for the plurality of backup load indications, wherein the set of load balancing metrics indicate a quantity of current backup jobs running on a first computing node of one or more computing nodes, the current backup jobs being associated with a backup job type comprising a transaction log backup job type or a database backup job type;
• receive, from the user of the data management platform, one or more second job requests of the database backup job type;
• determine a time taken to run a previous backup job at the first computing node, the previous backup job having the database backup job type;
• determine a backup load for the first computing node based at least in part on a subset of the quantity of current backup jobs running on the first computing node indicated in the metadata file and the time taken to run the previous backup job, wherein the subset of the quantity of current backup jobs has a same backup job type as the one or more second job requests, and wherein a remaining subset of the current backup jobs has a different backup job type from the one or more second job requests;
• and
• assign the one or more second job requests of the database backup job type to the first computing node based at least in part on the backup load for the first computing node determined based at least in part on the time taken to run the previous backup job at the first computing node.

A non-transitory computer-readable medium storing code, the code comprising instructions executable by at least one processor to:

• receive, from a user of a data management platform, a first job request to perform a backup of data from a data source to a database managed by the user of the data management platform, wherein the database is configured as a plurality of database instances running on a plurality of computing nodes of a computing cluster;
• store, in a metadata file, a backup load indication that indicates which computing node of the plurality of computing nodes is assigned to perform the backup of the data based at least in part on receiving the first job request, wherein the metadata file is configured to store a plurality of backup load indications for the database and a set of load balancing metrics for the plurality of backup load indications, wherein the set of load balancing metrics indicate a quantity of current backup jobs running on a first computing node of one or more computing nodes, the current backup jobs being associated with a backup job type comprising a transaction log backup job type or a database backup job type;
• receive, from the user of the data management platform, one or more second job requests of the database backup job type;
• determine a time taken to run a previous backup job at the first computing node, the previous backup job having the database backup job type;
• determine a backup load for the first computing node based at least in part on a subset of the quantity of current backup jobs running on the first computing node indicated in the metadata file and the time taken to run the previous backup job, wherein the subset of the quantity of current backup jobs has a same backup job type as the one or more second job requests, and wherein a remaining subset of the current backup jobs has a different backup job type from the one or more second job requests;
• and
• assign the one or more second job requests of the database backup job type to the first computing node based at least in part on the backup load for the first computing node determined based at least in part on the time taken to run the previous backup job at the first computing node.