Soru

Zorluk: OrtaResilient Database Configurations and High Availability

A healthcare software provider is deploying a web application on AWS that uses an Amazon Aurora PostgreSQL database. The application has strict compliance requirements:

1. High availability within the primary region (us-east-1) with a Recovery Time Objective (RTO) of less than 3030 seconds and a Recovery Point Objective (RPO) of 00 (no data loss).
2. A cross-region disaster recovery (DR) site in us-west-2 with an RTO of less than 1515 minutes and an RPO of less than 55 minutes. The DR region must also support low-latency read operations during normal business hours to serve local reports.

Which combination of configurations should the solutions architect implement to meet these requirements? (Select TWO.)

  1. Deploy an Amazon Aurora PostgreSQL DB cluster in the primary region with one or more Aurora Replicas placed in different Availability Zones.Cevap
  2. Create an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in us-west-2, and use the secondary cluster to serve local read traffic.Cevap
  3. C
    Deploy a single-instance Amazon RDS for PostgreSQL database in us-east-1 and configure a cross-region read replica in us-west-2 to automatically perform failover for the primary region.
  4. D
    Set up a Pilot Light disaster recovery strategy in us-west-2 by deploying an idle, single-node PostgreSQL database on an Amazon EC2 instance that is shut down and only started and synchronized daily from Amazon S3 database backups.
  5. E
    Configure an Amazon Route 53 Latency routing policy with health checks to automatically route database connection traffic between the database in us-east-1 and the database in us-west-2.

Cevap

Deploying an Amazon Aurora PostgreSQL DB cluster with replicas in different Availability Zones in the primary region, and creating an Amazon Aurora Global Database with a secondary cluster in the disaster recovery region.
Deploying an Amazon Aurora cluster with replicas across different Availability Zones guarantees high availability and automatic failover (RTO < 30 seconds) with zero data loss (RPO = 0) because Aurora replicates storage synchronously across three Availability Zones. Adding an Aurora Global Database to replicate asynchronously to us-west-2 provides an RPO of less than 1 second and can be promoted to primary in less than a minute, meeting the DR RTO/RPO requirements while allowing the secondary cluster to serve local read operations.

Adım Adım Çözüm

1
Evaluate the high availability requirement in the primary region (us-east-1).
Identify that an Amazon Aurora DB cluster with replicas in different Availability Zones provides automatic failover (RTO < 30 seconds) and synchronous replication across storage nodes (RPO of 0).
This configuration ensures that if the primary instance fails, a replica in another Availability Zone is promoted automatically with no data loss.
2
Evaluate the cross-region disaster recovery (DR) and read scaling requirements in us-west-2.
Identify that Amazon Aurora Global Databases replicate data asynchronously to a secondary region with an RPO of less than 1 second and an RTO of less than 1 minute when managed failover is used, while also allowing the secondary cluster to serve read traffic.
This satisfies the cross-region RTO (< 15 minutes) and RPO (< 5 minutes) limits and offloads reporting read traffic.
3
Eliminate configurations that do not support automatic failover or fail to meet the recovery objectives.
Reject using RDS read replicas for primary failover, setting up an EC2-based Pilot Light strategy with daily backups, and using Route 53 Latency routing for database failover.
These alternatives either lack automatic failover capabilities, exhibit recovery times and data loss exceeding the thresholds, or misapply DNS routing policies to database replication.

Anahtar Kavram

Amazon Aurora Multi-AZ and Global Databases provide high availability and cross-region disaster recovery by separating compute and storage replication layers.
Bu soruyu puanla