Performing multi-stream parallel incremental merge backups for clustered databases

1 . A method for managing data protection operations in a database system, the method comprising:

obtaining, by a computing node of the database system and from a data protection system, a data protection request for performing a data protection operation, wherein the data protection operation is an incremental merge operation to generate an incremental backup; and

in response to obtaining the data protection request:

identifying a selection of computing nodes in the database system for performing the data protection operation;

initiating, for each computing node in the selection, a mounting operation for mounting a full backup of the incremental backup;

determining a subset of the selection that successfully mount the full backup;

applying a data protection policy to assign a set of backup streams to each of the subset of the selection;

performing the data protection operation using the subset of the selection and the set of backup streams assigned to each of the subset to generate the incremental backup of a database managed by the database system; and

initiating, after the data protection operation, an unmounting on the subset of the selection.

2 . The method of claim 1 , further comprising:

prior to obtaining the data protection request: obtaining, by the data protection system, a configuration request for configuring the data protection operation; and

in response to the configuration request:

obtaining the selection of computing nodes;

for each computing node in the selection, obtaining a second set of backup streams to each of the selection of computing nodes; and

generating the data protection policy that specifies actions to perform for an unavailable computing node in the selection of computing nodes.

3 . The method of claim 2 , wherein a data protection configuration comprises the data protection policy, the selection of computing nodes, and the second set of backup streams, and wherein the data protection request comprises the data protection configuration.

4 . The method of claim 2 , wherein the data protection policy comprises at least one of: ignoring a first set of backup streams of the unavailable computing node, and redistributing the first set of backup streams among the subset of the selection.

5 . The method of claim 1 , further comprising:

prior to obtaining the data protection request: obtaining, by the data protection system, a discovery request for discovering the database system; and

in response to the discovery request:

determining that the database system is a clustered database comprising a plurality of computing nodes; and

obtaining, from each computing node in the plurality of computing nodes, node information comprising a hostname, a network address, and a fully qualified domain name (FQDN).

6 . The method of claim 1 , further comprising:

after initiating the unmounting, obtaining a response from one of the subset of the selection that indicates unsuccessful unmounting; and

in response to the response, performing a remediation for the unsuccessful unmounting.

7 . The method of claim 6 , wherein the remediation comprises notifying a database administrator of the unsuccessful unmounting and specifying performing a manual unmounting.

8 . A non-transitory computer readable medium comprising computer readable program code, which when executed by a computer processor enables the computer processor to perform a method for managing data protection operations in a database system, the method comprising:

obtaining, by a computing node of the database system and from a data protection system, a data protection request for performing a data protection operation, wherein the data protection operation is an incremental merge operation to generate an incremental backup; and

in response to obtaining the data protection request:

identifying a selection of computing nodes in the database system for performing the data protection operation;

initiating, for each computing node in the selection, a mounting operation for mounting a full backup of the incremental backup;

determining a subset of the selection that successfully mount the full backup;

applying a data protection policy to assign a set of backup streams to each of the subset of the selection;

performing the data protection operation using the subset of the selection and the set of backup streams assigned to each of the subset to generate the incremental backup of a database managed by the database system; and

initiating, after the data protection operation, an unmounting on the subset of the selection.

9 . The non-transitory computer readable medium of claim 8 , the method further comprising:

prior to obtaining the data protection request: obtaining, by the data protection system, a configuration request for configuring the data protection operation; and

in response to the configuration request:

obtaining the selection of computing nodes;

for each computing node in the selection, obtaining a second set of backup streams to each of the selection of computing nodes; and

generating the data protection policy that specifies actions to perform for an unavailable computing node in the selection of computing nodes.

10 . The non-transitory computer readable medium of claim 9 , wherein a data protection configuration comprises the data protection policy, the selection of computing nodes, and the second set of backup streams, and wherein the data protection request comprises the data protection configuration.

11 . The non-transitory computer readable medium of claim 9 , wherein the data protection policy comprises at least one of: ignoring a first set of backup streams of the unavailable computing node, and redistributing the first set of backup streams among the subset of the selection.

12 . The non-transitory computer readable medium of claim 8 , the method further comprising:

prior to obtaining the data protection request: obtaining, by the data protection system, a discovery request for discovering the database system; and

in response to the discovery request:

determining that the database system is a clustered database comprising a plurality of computing nodes; and

obtaining, from each computing node in the plurality of computing nodes, node information comprising a hostname, a network address, and a fully qualified domain name (FQDN).

13 . The non-transitory computer readable medium of claim 8 , the method further comprising:

after initiating the unmounting, obtaining a response from one of the subset of the selection that indicates unsuccessful unmounting; and

in response to the response, performing a remediation for the unsuccessful unmounting.

14 . The non-transitory computer readable medium of claim 13 , wherein the remediation comprises notifying a database administrator of the unsuccessful unmounting and specifying performing a manual unmounting.

15 . A system, comprising:

a data protection system;

a database system comprising a plurality of computing nodes,

wherein a computing node of the plurality of computing nodes comprises a processor; and

memory comprising instructions, which when executed by the processor, cause the processor to perform a method, the method comprising:

obtaining, from the data protection system, a data protection request for performing a data protection operation, wherein the data protection operation is an incremental merge operation to generate an incremental backup; and

in response to obtaining the data protection request:

identifying a selection of computing nodes in the database system for performing the data protection operation;

initiating, for each computing node in the selection, a mounting operation for mounting a full backup of the incremental backup;

determining a subset of the selection that successfully mount the full backup;

applying a data protection policy to assign a set of backup streams to each of the subset of the selection;

performing the data protection operation using the subset of the selection and the set of backup streams assigned to each of the subset to generate the incremental backup of a database managed by the database system; and

initiating, after the data protection operation, an unmounting on the subset of the selection.

16 . The system of claim 15 , the method further comprising:

prior to obtaining the data protection request: obtaining, by the data protection system, a configuration request for configuring the data protection operation; and

in response to the configuration request:

obtaining the selection of computing nodes;

for each computing node in the selection, obtaining a second set of backup streams to each of the selection of computing nodes; and

generating the data protection policy that specifies actions to perform for an unavailable computing node in the selection of computing nodes.

17 . The system of claim 16 , wherein a data protection configuration comprises the data protection policy, the selection of computing nodes, and the second set of backup streams, and wherein the data protection request comprises the data protection configuration.

18 . The system of claim 16 , wherein the data protection policy comprises at least one of: ignoring a first set of backup streams of the unavailable computing node, and redistributing the first set of backup streams among the subset of the selection.

19 . The system of claim 15 , the method further comprising:

after initiating the unmounting, obtaining a response from one of the subset of the selection that indicates unsuccessful unmounting; and

in response to the response, performing a remediation for the unsuccessful unmounting.

20 . The system of claim 19 , wherein the remediation comprises notifying a database administrator of the unsuccessful unmounting and specifying performing a manual unmounting.