System and method for cloning as SQL server AG databases in a hyperconverged system
A system and method include creating, by an Availability Group (“AG”) controller in a virtual computing system, a first AG clone from a source database. The source database is stored on a primary replica node of an AG of the virtual computing system. The system and method also include creating, by the Controller, a second AG clone from the first AG clone and storing, by the Controller, the second AG clone on a secondary replica node of the AG. The second AG clone has a size of substantially zero.
1. A method comprising:
creating, by a processor executing computer-readable instructions stored on a memory of a virtual computing system, a first Availability Group (AG) clone from a source database, wherein the first AG clone is stored on a primary replica node of an AG of the virtual computing system;
creating, by the processor, a second AG clone from a linked cloned disk captured from a snapshot of the first AG clone, wherein an empty transactional log captured from the first AG clone is applied to the linked cloned disk to create the second AG clone; and
storing, by the processor, the second AG clone on a secondary replica node of the AG.
2. The method of claim 1 , wherein the source database is stored on the primary replica node of the AG.
3. The method of claim 1 , wherein the first AG clone is created from another linked cloned disk captured from the source database.
4. The method of claim 1 , wherein multiple copies of the second AG clone are stored on the secondary replica node.
5. The method of claim 1 , wherein a size of the first AG clone is greater than the size of the second AG clone.
6. The method of claim 1 , wherein a size of the linked cloned disk is substantially zero.
7. A system comprising:
an Availability Group (AG) in a virtual computing system, the AG comprising a primary replica node and at least one secondary replica node;
a memory storing computer-readable instructions thereon; and
a processor that executes the computer-readable instructions to:
create a first AG clone from a source database, wherein the first AG clone is stored on the primary replica node;
create a second AG clone from a linked cloned disk captured from a snapshot of the first AG clone, wherein an empty transactional log captured from the first AG clone is applied to the linked cloned disk to create the second AG clone; and
store the second AG clone on the at least one secondary replica node.
8. The system of claim 7 , wherein the source database is stored on the primary replica node.
9. The system of claim 7 , wherein each of the at least one secondary replica nodes stores multiple copies of the second AG clone based upon a replication factor.
10. The system of claim 7 , wherein the at least one secondary replica nodes comprises a plurality of secondary replica nodes based upon a number of nodes in the AG.
11. The system of claim 7 , wherein a size of the first AG clone is greater than the size of the second AG clone.
12. The system of claim 7 , wherein the first AG clone is created from another linked cloned disk captured from the source database.
13. The system of claim 7 , wherein a size of the empty transactional log is substantially zero.
14. The system of claim 7 , wherein a size of the linked cloned disk is substantially zero.
15. A non-transitory computer-readable media comprising computer-readable instructions stored thereon that, when executed by a processor in a virtual computing system, causes the processor to:
create a first Availability Group (AG) clone from a source database, wherein the first AG clone is stored on a primary replica node of an AG;
create a second AG clone from a linked cloned disk captured from a snapshot of the first AG clone, wherein an empty transactional log captured from the first AG clone is applied to the linked cloned disk to create the second AG clone; and
store the second AG clone on at least one secondary replica node of the AG.
16. The non-transitory computer-readable media of claim 15 , wherein a size of the first AG clone is greater than the size of the second AG clone.
17. The non-transitory computer-readable media of claim 15 , wherein multiple copies of the second AG clone are stored on each of the at least one secondary replica node based on a replication factor.
18. The non-transitory computer-readable media of claim 15 , wherein the size of the linked cloned disk is substantially zero.
19. The non-transitory computer-readable media of claim 15 , wherein the first AG clone is created from another linked cloned disk captured from the source database.