Patching Or Updating SQL Server with multiple AlwaysOn Availability Groups - DBA Tutorial

In this video you will learn following:
1- How to patch or update SQL Server instances replicas with multiple Availability groups
2- How to free up replica to patch
3- How to failover Primary replica to it's secondary replica
4- How to execute windows patch on Availability groups replicas
5- How to test Availability groups after patching or updating
6- How to resume data movement in Availability group


General process steps


1-     Remove Automatic Failover on all synchronous-commit secondary replicas
2-     Upgrade all remote and secondary nodes
3-     Manually failover AG to updated secondary replica
4-     Make sure everything is working fine before you start primary replica
5-     Update primary replica
6-     Manually failback AG to primary replica
7-     Make sure everything is working fine
8-     Configure automatic failover, synchronous commit as it was before upgrade/patching

Patching/Updating AG with one Remote Secondary


1-     Change Synchronous commit to Asynchronous commit (If Any)
2-     Change Automatic Failover to Manual Failover
3-     Make sure AG Group is on Primary Replica
4-     Upgrade Secondary Replica (Remote Secondary)
5-     Failover over to secondary Replica (Remote)
6-     Upgrade Primary Replica
7-     Failback AG to Primary Replica
8-     Set Synchronous commit and Automatic Failover as it was before upgrade

Patching/Updating AG with Failover Cluster Instance





CLT01
CLT02
AG

NY01
NY02

1-     Failover SQL Server instance/instances to CLT01
2-     Upgrade CLT02
3-     Failover SQL Server instances on CLT02
4-     Make sure All works fine
5-     Repeat the process for NY01 and NY02
6-     Manual failover AG to NY instances from CLT
7-     Make sure all works fine.

 

 

 

Patching/Updating SQL Server instance with multiple AG groups


Note: Change Synchronous commit to Asynchronous and Automatic Failover to Manual Failover before performing below steps

1- Free up Replica 3 and patch or update
2- Failover AG to make sure all works fine
3- Free up Replica 2
4- Failover AG to make sure all works fine
5- Free up Replica 1
6- Failover AG and see if all works ok 


How to patch SQL Server with Multiple AlwaysOn Availability Groups - SQL Server DBA Tutorial

No comments:

Post a Comment