Posted On: May 24, 2018
Amazon RDS now offers Multi-AZ support for Amazon RDS for SQL Server in the Amazon Web Services China (Ningxia) Region operated by NWCD. 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 Amazon Web Services 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.
Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server Database deployments in the cloud