Posted On: Jun 9, 2016
Amazon RDS now offers Multi-AZ support for Amazon RDS for SQL Server in three new regions - Asia Pacific (Tokyo), Asia Pacific (Sydney) and South America (Sao Paulo) AWS Regions. This new high availability option leverages SQL Server Mirroring technology with additional improvements to meet the requirements of enterprise-grade production workloads running on SQL Server. The Multi-AZ deployment option provides enhanced availability and data durability by automatically replicating database updates between two AWS Availability Zones. Availability Zones are physically separate locations with independent infrastructure engineered to be insulated from failures in other Availability Zones.
When you create or modify your SQL Server database instance to run using Multi-AZ, Amazon RDS will automatically provision a primary database in one Availability Zone and maintain a synchronous "standby" replica in a different Availability Zone. 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 without any manual intervention.
Multi-AZ is available with Microsoft SQL Server 2008 R2 and 2012 Standard and Enterprise Editions. The increased availability and fault tolerance offered by Amazon RDS for SQL Server Multi-AZ are well suited for critical production environments using SQL Server.
Multi-AZ deployments for Amazon RDS for SQL Server are also available in the US East (N. Virginia), US West (Oregon), EU (Ireland) and Asia Pacific(Seoul) AWS regions.
To learn more, visit the Working with SQL Server Multi-AZ with Mirroring documentation.