Posted On: Feb 8, 2018
Amazon RDS Multi-AZ deployments address the high availability requirements of enterprise-grade production workloads. Amazon RDS for SQL Server now supports Multi-AZ in the Asia Pacific (Singapore) region. This new option leverages SQL Server Mirroring technology, with additional improvements.
AWS Availability Zones (AZs) are physically separate locations with independent infrastructure engineered to be insulated from failures in other Availability Zones. The Multi-AZ deployment option provides enhanced availability and data durability by automatically replicating database updates between two AZs.
You can create SQL Server database instances with the Multi-AZ option or modify existing instances. Amazon RDS will automatically provision a primary database in one AZ and maintain a synchronous "standby" replica in a different AZ. In the event of planned database maintenance or unplanned service disruption, Amazon RDS will automatically fail over the database to the up-to-date replica so that database operations can resume quickly without any manual intervention.