Soru

Zorluk: OrtaDatabase High Availability

A company runs a critical application using a single-node Amazon RDS for PostgreSQL DB instance. A SysOps Administrator has set up a read-only reporting environment by adding an RDS Read Replica. During a review of the disaster recovery plan, the administrator needs to ensure that the primary database has high availability with automatic failover and zero data loss in the event of an Availability Zone outage. Which action should the administrator take to meet these requirements with the shortest recovery time?

  1. Modify the DB instance to enable the Multi-AZ deployment option.Cevap
  2. B
    Configure Amazon Route 53 with a failover routing policy pointing to the Read Replica endpoint.
  3. C
    Create an Amazon EventBridge rule to trigger an AWS Lambda function that promotes the Read Replica when the primary instance becomes unhealthy.
  4. D
    Modify the Read Replica to enable Multi-AZ replication and use its endpoint as the primary connection string.

Cevap

Modify the DB instance to enable the Multi-AZ deployment option.
Enabling the Multi-AZ option on the primary RDS DB instance replicates data synchronously to a standby instance in a different Availability Zone. If the primary instance fails, AWS automatically updates the DNS record to point to the standby instance, ensuring automatic failover with zero data loss and the shortest recovery time.

Adım Adım Çözüm

1
Analyze the business requirements for database high availability.
The solution must support automatic failover, zero data loss (synchronous replication), and recover from Availability Zone outages with minimal recovery time.
Establishing the requirements isolates the native Multi-AZ feature as the correct target architecture.
2
Evaluate the capabilities of Amazon RDS Multi-AZ deployments.
RDS Multi-AZ replicates data synchronously to a standby instance in a different Availability Zone and performs automatic DNS updates during failover, guaranteeing zero data loss.
This aligns perfectly with the requirement for zero data loss and automated failover.
3
Compare against Read Replica alternatives.
Read replicas utilize asynchronous replication, which introduces data loss risk (non-zero Recovery Point Objective) and requires manual or scripted promotion, increasing recovery time.
This disqualifies replica-based solutions for primary database high availability.

Anahtar Kavram

Amazon RDS Multi-AZ deployments provide synchronous replication, automatic failover, and high availability across Availability Zones within an AWS Region.
Tahmini Süre:1m 30s
Bu soruyu puanla