Embedded Files
Automatic Patching
Automatic Patching
Minor version updates are usually applied automatically by AWS if you enable the auto minor version upgrade option.
AWS lets you choose when to apply patches by selecting a maintenance window.
Impact: These updates cause a restart of the SQL Server instance, so there will be a short outage.
Best Practice: Set your maintenance window appropriately.
Multi-AZ (High Availability) Deployment
Multi-AZ (High Availability) Deployment
If your RDS instance is Multi-AZ, AWS can apply patches without significant downtime:
AWS will apply the patch to the standby instance first, and once it’s updated, it will promote it to the primary role.
After the failover, the previous primary will be patched and become the standby.
Impact: A failover will occur. Existing connections will be dropped and applications will need to reconnect.
Note: Multi-AZ RDS is NOT the same as an Always On Availability Group
RDS Multi-AZ gives you “Always On–like availability with training wheels”; EC2 + AGs gives you “full Always On power, speed, and responsibility.” (ChatGPT)
Read Replicas
Read Replicas
If you have read replicas, they’ll be patched automatically in sync with the primary instance, but the read replicas will not incur downtime during the patching, as long as the replicas are functioning as expected.
You may experience replication lag during this process, but the downtime impact on users is minimized.
Page updated
Google Sites
Report abuse