System and method for availability group database patching

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.

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.