System and method for availability group database patching

1. A method comprising:

receiving, by a processor executing computer-readable instructions stored on a memory, a request to apply a patch on a plurality of nodes, one of the plurality of nodes being a primary replica node and remaining nodes of the plurality of nodes being a secondary replica node;

selecting, by the processor, a next node from the plurality of nodes for patching based on a first priority, wherein the first priority is assigned such that each of the secondary replica node is selected before the primary replica node, and wherein the first priority is dynamically updated each time before selecting the next node based on a current state of the plurality of nodes;

selecting, by the processor, a failover target node based on a second priority for patching the primary replica node after patching the each of the secondary replica node; and

patching, by the processor, the primary replica node upon failing over the primary replica node to the failover target node,

wherein according to the second priority, a healthy synchronous secondary replica node is selected as the failover target node before an unhealthy synchronous secondary replica node.

2. The method of claim 1 , wherein the first priority is a positive integer value and the second priority is a negative integer value.

3. The method of claim 1 , wherein selecting the secondary replica node according to the first priority comprises selecting an asynchronous secondary replica node before a synchronous replica node.

4. The method of claim 3 , further comprising selecting the healthy synchronous secondary replica node for patching before the unhealthy synchronous secondary replica node.

5. The method of claim 4 , further comprising selecting the healthy synchronous secondary replica node that is remote for patching before the healthy synchronous secondary replica node that is local.

6. The method of claim 1 , wherein the first priority for the primary replica node is computed based on a sum of a pre-determined integer value and a number of availability groups on the primary replica node.

7. The method of claim 1 , wherein selecting the failover target node according to the second priority further comprises selecting the healthy synchronous secondary replica node that is patched before the healthy synchronous secondary replica node that is unpatched.

8. The method of claim 1 , wherein selecting the failover target node according to the second priority further comprises selecting the healthy synchronous secondary replica node and the unhealthy synchronous secondary replica node before an asynchronous secondary replica node.

9. A system comprising:

a memory having computer-readable instructions stored thereon; and

a processor executing the computer-readable instructions to:

receive a request to apply a patch on a plurality of nodes, one of the plurality of nodes being a primary replica node and remaining nodes of the plurality of nodes being a secondary replica node;

select a next node from the plurality of nodes to patch based on a first priority, wherein the first priority is assigned such that each of the secondary replica node is selected before the primary replica node, and wherein the first priority is dynamically updated each time before selecting the next node based on a current state of the plurality of nodes;

select a failover target node based on a second priority to patch the primary replica node after patching the each of the secondary replica node; and

patch the primary replica node upon failing over the primary replica node to the failover target node,

wherein according to the second priority, a healthy synchronous secondary replica node is selected as the failover target node before an unhealthy synchronous secondary replica node.

10. The system of claim 9 , wherein the first priority is a positive integer value and the second priority is a negative integer value.

11. The system of claim 9 , wherein to select the secondary replica node according to the first priority, the processor further executes computer-readable instructions to select an asynchronous secondary replica node before a synchronous replica node.

12. The system of claim 11 , wherein the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node for patching before the unhealthy synchronous secondary replica node.

13. The system of claim 12 , wherein the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node that is remote for patching before the healthy synchronous secondary replica node that is local.

14. The system of claim 9 , wherein the first priority for the primary replica node is computed based on a sum of a pre-determined integer value and a number of availability groups on the primary replica node.

15. The system of claim 9 , wherein to select the failover target node according to the second priority, the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node that is patched before the healthy synchronous secondary replica node that is unpatched.

16. The system of claim 9 , wherein to select the failover target node according to the second priority, the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node and the unhealthy synchronous secondary replica node before an asynchronous secondary replica node.

17. A non-transitory computer-readable media comprising computer-readable instructions stored thereon that when executed by a processor cause the processor to:

receive a request to apply a patch on a plurality of nodes, one of the plurality of nodes being a primary replica node and remaining nodes of the plurality of nodes being a secondary replica node;

select a next node from the plurality of nodes to patch based on a first priority, wherein the first priority is assigned such that each of the secondary replica node is selected before the primary replica node, and wherein the first priority is dynamically updated each time before selecting the next node based on a current state of the plurality of nodes;

select a failover target node based on a second priority to patch the primary replica node after patching the each of the secondary replica node; and

patch the primary replica node upon failing over the primary replica node to the failover target node,

wherein according to the second priority, a healthy synchronous secondary replica node is selected as the failover target node before an unhealthy synchronous secondary replica node.

18. The non-transitory computer-readable media of claim 17 , wherein the first priority is a positive integer value and the second priority is a negative integer value.

19. The non-transitory computer-readable media of claim 17 , wherein to select the secondary replica node according to the first priority, the processor further executes computer-readable instructions to select an asynchronous secondary replica node before a synchronous replica node.

20. The non-transitory computer-readable media of claim 19 , wherein the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node for patching before the unhealthy synchronous secondary replica node.

21. The non-transitory computer-readable media of claim 20 , wherein the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node that is remote for patching before the healthy synchronous secondary replica node that is local.

22. The non-transitory computer-readable media of claim 17 , wherein the first priority for the primary replica node is computed based on a sum of a pre-determined integer value and a number of availability groups on the primary replica node.

23. The non-transitory computer-readable media of claim 17 , wherein to select the failover target node according to the second priority, the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node that is patched before the healthy synchronous secondary replica node that is unpatched.

24. The non-transitory computer-readable media of claim 17 , wherein to select the failover target node according to the second priority, the processor further executes computer-readable instructions to select the healthy synchronous secondary replica node and the unhealthy synchronous secondary replica node before an asynchronous secondary replica node.

25. The method of claim 1 , wherein the patching of the plurality of nodes is performed using a software profile.

26. The method of claim 25 , wherein the patching using the software profile comprises:

creating a new version of the software profile based on the patch;

cloning the new version of the software profile on a node of the plurality of nodes that is being patched; and

migrating old data from the node to the new version of the software profile.

27. The method of claim 1 , wherein the plurality of nodes are part of an availability group in which the primary replica node stores an availability database and each of the secondary replica node store a copy of the availability database.

28. The method of claim 1 , wherein the first priority of each of the secondary replica node is higher than the primary replica node, and wherein a highest priority node is selected as the next node for patching.

29. The system of claim 9 , wherein the patching of the plurality of nodes is performed using a software profile.

30. The system of claim 29 , wherein to patch using the software profile, the processor further executes computer-readable instructions to:

create a new version of the software profile based on the patch;

clone the new version of the software profile on a node of the plurality of nodes that is being patched; and

migrate old data from the node to the new version of the software profile.

31. The system of claim 9 , wherein the plurality of nodes are part of an availability group in which the primary replica node stores an availability database and each of the secondary replica node store a copy of the availability database.

32. The system of claim 9 , wherein the first priority of each of the secondary replica node is higher than the primary replica node, and wherein a highest priority node is selected as the next node for patching.

33. The non-transitory computer-readable media of claim 17 , wherein the patching of the plurality of nodes is performed using a software profile.

34. The non-transitory computer-readable media of claim 33 , wherein to patch using the software profile, the processor further executes computer-readable instructions to:

create a new version of the software profile based on the patch;

clone the new version of the software profile on a node of the plurality of nodes that is being patched; and

migrate old data from the node to the new version of the software profile.

35. The non-transitory computer-readable media of claim 17 , wherein the plurality of nodes are part of an availability group in which the primary replica node stores an availability database and each of the secondary replica node store a copy of the availability database.

36. The non-transitory computer-readable media of claim 17 , wherein the first priority of each of the secondary replica node is higher than the primary replica node, and wherein a highest priority node is selected as the next node for patching.