DECOUPLED BACKUP SOLUTION FOR DISTRIBUTED DATABASES ACROSS A FAILOVER CLUSTER
A decoupled backup solution for distributed databases across a failover cluster. Specifically, a method and system disclosed herein improve upon a limitation of existing backup mechanisms involving distributed databases across a failover cluster. The limitation entails restraining backup agents, responsible for executing database backup processes across the failover cluster, from immediately initiating these aforementioned processes upon receipt of instructions. Rather, due to this limitation, these backup agents must wait until all backup agents, across the failover cluster, receive their respective instructions before being permitted to initiate the creation of backup copies of their relative distributed database. Subsequently, the limitation imposes an initiation delay on the backup processes, which the disclosed method and system omit, thereby granting any particular backup agent the capability to immediately (i.e., without delay) initiate those backup processes.
1 . A method for optimizing distributed database backups, comprising:
receiving, at a secondary node, a secondary data backup request from a primary node; and
while at least one other secondary node has yet to receive another secondary data backup request from the primary node:
initiating, in response to the secondary data backup request, a secondary data backup process on the secondary node.
2 . The method of claim 1 , wherein the secondary data backup process, comprises:
creating a backup copy of a passive database copy (PDC) that is one selected from a group consisting of hosted on and operatively connected to, the secondary node; and
submitting the backup copy for remote consolidation on a cluster backup storage system (BSS).
3 . The method of claim 2 , wherein the backup copy is one selected from a group consisting of a full database backup, a differential database backup, and a transaction log backup.
4 . The method of claim 2 , wherein the PDC is a standby database copy of an active database copy (ADC).
5 . The method of claim 4 , wherein the ADC is one selected from a group consisting of hosted on and operatively connected to, the primary node.
6 . The method of claim 1 , wherein the secondary node and the at least one other secondary node are standby nodes for the primary node.
7 . The method of claim 1 , further comprising:
generating a data backup report based on an outcome of the secondary data backup process; and
issuing the data backup report to the primary node.
8 . A system, comprising:
a plurality of database failover nodes (DFNs);
a primary backup agent (PBA) executing on a first DFN of the plurality of DFNs; and
a secondary backup agent (SBA) executing on a second DFN of the plurality of DFNs,
wherein the SBA is operatively connected to the PBA, and programmed to:
receive a secondary data backup request from the PBA; and
while at least one other SBA has yet to receive another secondary data backup request from the PBA:
initiate, in response to the secondary data backup request, a secondary data backup process on the second DFN.
9 . The system of claim 8 , further comprising:
a third DFN of the plurality of DFNs,
wherein the at least one other SBA executes on the third DFN, and is operatively connected to the PBA.
10 . The system of claim 8 , further comprising:
a passive database copy (PDC) that is one selected from a group consisting of hosted on and operatively connected to, the second DFN,
wherein the secondary data backup process comprises creating a backup copy of the PDC.
11 . The system of claim 8 , wherein the PBA is programmed to:
prior to the SBA receiving the secondary data backup request:
receive a first data backup request; and
in response to the first data backup request:
initiate a primary data backup process on the first DFN; and
issue, after initiating the primary data backup process, at least one secondary data backup request to at least one SBA,
wherein the at least one secondary data backup request comprises the secondary data backup request and the another secondary data backup request,
wherein the at least one SBA comprises the SBA and the at least one other SBA.
12 . The system of claim 11 , further comprising:
a cluster administrator client (CAC) operatively connected to the PBA,
wherein the first data backup request is received from the CAC.
13 . The system of claim 12 , wherein the PBA is further programmed to:
obtain a first outcome based on performing the primary data backup process;
receive, from the SBA, a data backup report specifying a second outcome based on a performance of the secondary data backup process; and
receive, from the at least one other SBA, at least one other data backup report specifying at least one other outcome based on at least one other performance of at least one other secondary data backup process;
generate an aggregated data backup report based on the first outcome, the second outcome, and the at least one other outcome; and
issue the aggregated data backup report to the CAC.
14 . The system of claim 11 , further comprising:
an active database copy (ADC) that is one selected from a group consisting of hosted on and operatively connected to, the first DFN,
wherein the primary data backup process comprises creating a backup copy of the ADC.
15 . The system of claim 8 , further comprising:
a database failover cluster (DFC) comprising the plurality of DFNs.
16 . The system of claim 8 , further comprising:
a cluster backup storage system (BSS) operatively connected to the plurality of DFNs,
wherein the secondary data backup process comprises creating a backup copy and consolidating the backup copy in the cluster BSS.
17 . A non-transitory computer readable medium (CRM) comprising computer readable program code, which when executed by a computer processor, enables the computer processor to:
receive, at a secondary node, a secondary data backup request from a primary node; and
while at least one other secondary node has yet to receive another secondary data backup request from the primary node:
initiate, in response to the secondary data backup request, a secondary data backup process on the secondary node.
18 . The non-transitory CRM of claim 17 , wherein the secondary data backup process, comprises enabling the computer processor to:
create a backup copy of a passive database copy (PDC) that is one selected from a group consisting of hosted on and operatively connected to, the secondary node; and
submit the backup copy for remote consolidation on a cluster backup storage system (BSS).
19 . The non-transitory CRM of claim 17 , wherein the secondary node and the at least one other secondary node are standby nodes for the primary node.
20 . The non-transitory CRM of claim 17 , further comprising computer readable program code, which when executed by the computer processor, enables the computer processor to:
generate a data backup report based on an outcome of the secondary data backup process; and
issue the data backup report to the primary node.