Articles → AWS → Multi-AZ Database Instance Deployment In AWS

Multi-AZ Database Instance Deployment In AWS

Purpose

Which Events Are Failover Events?

1. Loss of primary AZ
2. Primary DB instance failure
3. Loss of network connectivity on primary
4. Patching activity on the primary database instance
5. Manual failover of primary database

How Is The Database Synchronized In Multi-AZ Instance Deployment?

1. RDS takes a snapshot of the primary database
2. RDS restores the snapshot in another AZ

How To Enable Multi-AZ Database Instance Deployment?

Can We Use SQL Server For Multi-AZ Database Instance Deployment?

Is There Any Cost Associated With Data Transfer Between The Primary And Standby Databases?

How The Maintenance Activities Are Done In Multi-AZ?

1. Perform operations on standby
2. Promote standby to primary
3. Perform operations on new standby (demoted primary)