Protecting databases in a clusterless availability group
A determination is made that a backup of a database in an availability group provided by a relational database management system (RDBMS) should be performed. The availability group includes a node functioning as a primary node and hosting a primary replica of the database and one or more other nodes functioning as secondary nodes and hosting secondary replicas of the database. The availability group is a clusterless availability group in which the one or more other nodes functioning as secondary nodes are not available as automatic failover targets should the primary node become unavailable. A command is issued to a node in the availability group to obtain a globally unique identifier (GUID) of the availability group. The node is instructed to index a backup of the database against the GUID of the availability group.
1. A method comprising:
determining that a backup of a database in an availability group provided by a relational database management system (RDBMS) should be performed, the availability group comprising a node functioning as a primary node and hosting a primary replica of the database, and one or more other nodes functioning as secondary nodes and hosting secondary replicas of the database,
wherein the primary replica is available for read-write connections and the secondary replicas are available for read-only connections, and
wherein the availability group is a clusterless availability group in which the one or more other nodes functioning as secondary nodes are not available as automatic failover targets should the primary node become unavailable;
issuing, to a node in the availability group, a command to obtain a globally unique identifier (GUID) of the availability group; and
directing, for an initial backup of the database, the node to backup a replica of the database being hosted by the node, the directing for the initial backup comprising instructing the node to index the initial backup against the GUID of the availability group, wherein the indexing of the initial backup against the GUID of the clusterless availability group thereby allows a subsequent backup of the database conducted using a different node in the availability group to be linked to the initial backup despite the subsequent backup being conducted using the different node.
2. The method of claim 1 wherein the GUID of the availability group is generated and assigned to the availability group by the RDBMS.
3. The method of claim 1 wherein the node in the availability group is a first node and the method further comprises:
directing, for the subsequent backup of the database, a second node in the availability group to backup a replica of the database being hosted by the second node, the directing for the subsequent backup comprising instructing the second node to index the subsequent backup against the GUID of the availability group, and
wherein the initial backup of the database comprises a full backup, and the subsequent backup of the database comprises a differential backup.
4. The method of claim 3 further comprising:
linking the initial and subsequent backups of the database using the GUID of the availability group.
5. The method of claim 1 wherein the GUID of the availability group is different from a name of the node and a name assigned to the availability group by a user.
6. The method of claim 1 wherein after the initial backup of the database is completed, the database is forced by a user to failover to another node in the availability group, the other node being a second node, and the method further comprises:
issuing, to the second node in the availability group, a command to obtain the GUID of the availability group; and
directing, for the subsequent backup of the database, the second node to backup a replica of the database being hosted by the second node, the directing for the subsequent backup comprising instructing the second node to index the subsequent backup against the GUID of the availability group.
7. A system comprising: a processor; and memory configured to store one or more sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
determining that a backup of a database in an availability group provided by a relational database management system (RDBMS) should be performed, the availability group comprising a node functioning as a primary node and hosting a primary replica of the database, and one or more other nodes functioning as secondary nodes and hosting secondary replicas of the database,
wherein the primary replica is available for read-write connections and the secondary replicas are available for read-only connections, and
wherein the availability group is a clusterless availability group in which the one or more other nodes functioning as secondary nodes are not available as automatic failover targets should the primary node become unavailable;
issuing, to a node in the availability group, a command to obtain a globally unique identifier (GUID) of the availability group; and
directing, for an initial backup of the database, the node to backup a replica of the database being hosted by the node, the directing for the initial backup comprising instructing the node to index the initial backup against the GUID of the availability group, wherein the indexing of the initial backup against the GUID of the clusterless availability group thereby allows a subsequent backup of the database conducted using a different node in the availability group to be linked to the initial backup despite being the subsequent backup being conducted using the different node.
8. The system of claim 7 wherein the GUID of the availability group is generated and assigned to the availability group by the RDBMS.
9. The system of claim 7 wherein the node in the availability group is a first node and the processor further carries out the steps of:
directing, for the subsequent backup of the database, a second node in the availability group to backup a replica of the database being hosted by the second node, the directing for the subsequent backup comprising instructing the second node to index the subsequent backup against the GUID of the availability group, and
wherein the initial backup of the database comprises a full backup, and the subsequent backup of the database comprises a differential backup.
10. The system of claim 9 wherein the processor further carries out the steps of:
linking the initial and subsequent backups of the database using the GUID of the availability group.
11. The system of claim 7 wherein the GUID of the availability group is different from a name of the node and a name assigned to the availability group by a user.
12. The system of claim 7 wherein after the initial backup of the database is completed, the database is forced by a user to failover to another node in the availability group, the other node being a second node, and the processor further carries out the steps of:
issuing, to the second node in the availability group, a command to obtain the GUID of the availability group; and
directing, for the subsequent backup of the database, the second node to backup a replica of the database being hosted by the second node, the directing for the subsequent backup comprising instructing the second node to index the subsequent backup against the GUID of the availability group.
13. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein, the computer-readable program code adapted to be executed by one or more processors to implement a method comprising:
determining that a backup of a database in an availability group provided by a relational database management system (RDBMS) should be performed, the availability group comprising a node functioning as a primary node and hosting a primary replica of the database, and one or more other nodes functioning as secondary nodes and hosting secondary replicas of the database,
wherein the primary replica is available for read-write connections and the secondary replicas are available for read-only connections, and
wherein the availability group is a clusterless availability group in which the one or more other nodes functioning as secondary nodes are not available as automatic failover targets should the primary node become unavailable;
issuing, to a node in the availability group, a command to obtain a globally unique identifier (GUID) of the availability group; and
directing, for an initial backup of the database, the node to backup a replica of the database being hosted by the node, the directing for the initial backup comprising instructing the node to index the initial backup against the GUID of the availability group, wherein the indexing of the initial backup against the GUID of the clusterless availability group thereby allows a subsequent backup of the database conducted using a different node in the availability group to be linked to the initial backup despite the subsequent backup being conducted using the different node.
14. The computer program product of claim 13 wherein the GUID of the availability group is generated and assigned to the availability group by the RDBMS.
15. The computer program product of claim 13 wherein the node in the availability group is a first node and the method further comprises:
directing, for the subsequent backup of the database, a second node in the availability group to backup a replica of the database being hosted by the second node, the directing for the subsequent backup comprising instructing the second node to index the subsequent backup against the GUID of the availability group, and
wherein the initial backup of the database comprises a full backup, and the subsequent backup of the database comprises a differential backup.
16. The computer program product of claim 15 wherein the method further comprises:
linking the initial and subsequent backups of the database using the GUID of the availability group.
17. The computer program product of claim 13 wherein the GUID of the availability group is different from a name of the node and a name assigned to the availability group by a user.
18. The computer program product of claim 13 wherein after the initial backup of the database is completed, the database is forced by a user to failover to another node in the availability group, the other node being a second node, and the method further comprises:
issuing, to the second node in the availability group, a command to obtain the GUID of the availability group; and
directing, for the subsequent backup of the database, the second node to backup a replica of the database being hosted by the second node, the directing for the subsequent backup comprising instructing the second node to index the subsequent backup against the GUID of the availability group.
19. The method of claim 1 further comprising:
based on the indexing of the initial backup against the GUID of the availability group, recognizing, at the subsequent backup of the database conducted at the different node in the availability group, that the initial backup of the database has been previously performed.