All 7 RDS & Databases questions
More in RDS & Databases
What is Amazon RDS and what benefits does it provide over managing a database server yourself on EC2? What is the difference between an RDS read replica and a Multi-AZ standby instance, and when should you use each? What is Amazon Aurora, and how does it differ from standard RDS MySQL or PostgreSQL in terms of performance and architecture? How does automated backup and point in time recovery work in RDS, and what recovery options does it provide? How does RDS Proxy help applications manage database connections more efficiently, particularly for serverless architectures using Lambda? How should an organization design a comprehensive database resilience and disaster recovery strategy combining Multi-AZ, read replicas, cross region replication, and automated backups?
Advertisement
AWS › RDS & Databases

What is Multi-AZ deployment in RDS, and how does it improve database availability?

Beginner

Answer

A Multi-AZ deployment automatically maintains a synchronously replicated standby copy of your database in a different Availability Zone, and if the primary database instance becomes unavailable due to an infrastructure failure, RDS automatically fails over to the standby instance within a short amount of time, all without requiring any manual intervention, significantly improving database availability compared to running a single database instance in only one Availability Zone.
aws rds create-db-instance --db-instance-identifier my-database --multi-az --engine postgres --db-instance-class db.t3.medium
Real-world example A company running a critical production database enables Multi-AZ deployment, ensuring that if the underlying hardware hosting the primary database instance fails, RDS automatically fails over to the synchronized standby instance within about a minute, minimizing downtime.

Common follow-ups: How does Multi-AZ differ from creating a manually configured read replica?;What is the typical failover time for a Multi-AZ deployment?

AWS Backup & Disaster Recovery;AWS Global Infrastructure (Regions AZs & Edge Locations)
All 7 RDS & Databases questions