Posted On: Aug 3, 2017
Amazon RDS for SQL Server now offers Multi-AZ support in the EU Central (Frankfurt) region. 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.
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.