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

Multi-AZ Database Instance Deployment In AWS


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?

Picture showing enabling the option for creating the multi AZ DB
Click to Enlarge

Picture showing the value of Multi-AZ column as Yes
Click to Enlarge

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)

Posted By  -  Karan Gupta
Posted On  -  Friday, January 14, 2022
Updated On  -  Wednesday, February 7, 2024


Your Email Id  
Query/FeedbackCharacters remaining 250