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, a first clone from a first linked cloned disk created from a first snapshot captured from a source database; and
creating, by the processor, a second clone from a second linked cloned disk created from a second snapshot captured from the first clone, wherein an empty transactional log captured from the first clone is applied to the second linked cloned disk to create the second clone, and wherein the source database, the first clone, and the second clone are part of an always on availability group.
2. The method of claim 1 , further comprising applying, by the processor, a non-empty transactional log captured from the source database to the first linked cloned disk for creating the first clone.
3. The method of claim 1 , further comprising:
storing, by the processor, the first clone at a first location; and
storing, by the processor, the second clone at a second location different than the first location.
4. The method of claim 3 , wherein the first location and the second location each comprise a cloud location associated with the always on availability group.
5. The method of claim 3 , further comprising storing, by the processor, the source database at the first location.
6. The method of claim 3 , wherein each of the first location and the second location is a node of a cluster associated with the always on availability group.
7. The method of claim 3 , further comprising storing, by the processor, the second clone at additional locations.
8. The method of claim 1 , further comprising capturing, by the processor, the first snapshot and the second snapshot based on a service level agreement associated with the source database.
9. The method of claim 1 , wherein a size of the first clone is greater than the size of the second clone.
10. The method of claim 1 , further comprising:
storing, by the processor, the first clone and one or more copies of the first clone at a first location based on a first replication factor; and
storing, by the processor, the second clone and one or more copies of the second clone at a second location based on a second replication factor.
11. A system comprising:
a memory having computer-readable instructions stored thereon; and
a processor that executes the computer-readable instructions to:
create a first clone from a first linked cloned disk created from a first snapshot captured from a source database; and
create a second clone from a second linked cloned disk created from a second snapshot captured from the first clone, wherein an empty transactional log captured from the first clone is applied to the second linked cloned disk to create the second clone, and wherein the source database, the first clone, and the second clone are part of an always on availability group.
12. The system of claim 11 , wherein the processor further executes computer-readable instructions to apply a non-empty transactional log captured from the source database to the first linked cloned disk for creating the first clone.
13. The system of claim 11 , wherein the processor further executes computer-readable instructions to:
store the first clone at a first location; and
store the second clone at a second location different than the first location.
14. The system of claim 13 , wherein the first location and the second location each comprise a cloud location associated with the always on availability group.
15. The system of claim 13 , wherein the processor further executes computer-readable instructions to store the source database at the first location.
16. The system of claim 13 , wherein each of the first location and the second location is a node of a cluster associated with the always on availability group.
17. The system of claim 13 , wherein the processor further executes computer-readable instructions to store the second clone at additional locations.
18. The system of claim 11 , wherein the processor further executes computer-readable instructions to capture the first snapshot and the second snapshot based on a service level agreement associated with the source database.
19. The system of claim 11 , wherein a size of the first clone is greater than the size of the second clone.
20. The system of claim 11 , wherein the processor further executes computer-readable instructions to:
store the first clone and one or more copies of the first clone at a first location based on a first replication factor; and
store the second clone and one or more copies of the second clone at a second location based on a second replication factor.
21. A non-transitory computer-readable media comprising computer-readable instructions stored thereon that when executed by a processor cause the processor to:
create a first clone from a first linked cloned disk created from a first snapshot captured from a source database; and
create a second clone from a second linked cloned disk created from a second snapshot captured from the first clone, wherein an empty transactional log captured from the first clone is applied to the second linked cloned disk to create the second clone, and wherein the source database, the first clone, and the second clone are part of an always on availability group.
22. The non-transitory computer-readable media of claim 21 , wherein the processor further executes computer-readable instructions to apply a non-empty transactional log captured from the source database to the first linked cloned disk for creating the first clone.
23. The non-transitory computer-readable media of claim 21 , wherein the processor further executes computer-readable instructions to:
store the first clone at a first location; and
store the second clone at a second location different than the first location.
24. The non-transitory computer-readable media of claim 23 , wherein the first location and the second location each comprise a cloud location associated with the always on availability group.
25. The non-transitory computer-readable media of claim 23 , wherein the processor further executes computer-readable instructions to store the source database at the first location.
26. The non-transitory computer-readable media of claim 23 , wherein each of the first location and the second location is a node of a cluster associated with the always on availability group.
27. The non-transitory computer-readable media of claim 23 , wherein the processor further executes computer-readable instructions to store the second clone at additional locations.
28. The non-transitory computer-readable media of claim 21 , wherein the processor further executes computer-readable instructions to capture the first snapshot and the second snapshot based on a service level agreement associated with the source database.
29. The non-transitory computer-readable media of claim 21 , wherein a size of the first clone is greater than the size of the second clone.
30. The non-transitory computer-readable media of claim 21 , wherein the processor further executes computer-readable instructions to:
store the first clone and one or more copies of the first clone at a first location based on a first replication factor; and
store the second clone and one or more copies of the second clone at a second location based on a second replication factor.