Amazon RDS for SQL Server Now Supports Always On Availability Groups

Posted on: Nov 8, 2018

Amazon RDS for SQL Server now offers Always On Availability Groups for the Multi-AZ configuration in all AWS Regions. This new high availability option meets the requirements of enterprise-grade production workloads on SQL Server. 

The Multi-AZ deployment option provides enhanced availability and data durability by automatically replicating databases between two AWS Availability Zones. These Availability Zones offer you an easier and more effective way to design and operate applications and databases, making them more highly available, fault tolerant, and scalable than traditional single datacenter infrastructures or multi-datacenter infrastructures.

When you create or modify your SQL Server database instance to run using Multi-AZ on SQL Server 2016 latest minor version (13.00.5216.0.v1) for the Enterprise Edition database engine, Amazon RDS will automatically provision a primary database in one Availability Zone and maintain a synchronous "standby" replica in a different Availability Zone using Always On Availability Groups. In the event of planned database maintenance or unplanned service disruption, Amazon RDS will automatically fail over the SQL Server database to the up-to-date standby so that database operations can resume quickly.

With an Always On Availability Group setup you can easily connect to the listener endpoint in order to have faster failover times to learn more visit the Amazon RDS User Guide.

Please visit Amazon RDS for SQL Server Pricing for complete regional availability information.