Examkin

Question

Difficulty: MediumResilient Database Configurations and High Availability

A digital ticketing platform plans to migrate its database to Amazon Aurora MySQL. The database must sustain high availability during an Availability Zone outage with a recovery time objective (RTO) of less than 60 seconds and zero data loss (recovery point objective or RPO of 0). In addition, the database must dynamically scale to support a large, unpredictable volume of read queries. Which two configurations should a solutions architect implement to meet these requirements? (Select TWO.)

  1. Deploy the database as an Amazon Aurora cluster with a primary instance and one or more Aurora Replicas in different Availability Zones.Answer
  2. Configure the application to use the Aurora reader endpoint and enable Aurora Auto Scaling for the reader instances.Answer
  3. C
    Deploy the database as a single-AZ Amazon Aurora instance and create an Aurora Read Replica in a second Availability Zone to perform manual failover.
  4. D
    Deploy a pilot light backup database in a secondary Region and configure Route 53 failover to achieve sub-minute automatic failover.
  5. E
    Use Amazon Route 53 latency routing policies to distribute database write operations across all active replica instances.

Answer

Deploy the database as an Amazon Aurora cluster with a primary instance and Aurora Replicas in different Availability Zones, and configure the application to use the Aurora reader endpoint while enabling Aurora Auto Scaling.
Deploying the database as a Multi-AZ Amazon Aurora cluster with replicas in multiple Availability Zones ensures that if the primary instance fails, Aurora automatically promotes a replica within 30 seconds with no data loss because all replicas share the cluster's distributed storage volume. Routing read traffic to the reader endpoint and enabling Aurora Auto Scaling ensures the database dynamically handles spikes in read queries by automatically scaling the number of read replicas.

Step-by-Step Solution

1
Analyze high availability (RTO/RPO) requirements.
Identified that RTO must be under 60 seconds and RPO must be 0 (no data loss) in case of an Availability Zone outage.
This necessitates automatic failover and synchronous-like storage replication within the region.
2
Evaluate the database deployment model.
Selecting a Multi-AZ cluster deployment with Aurora Replicas across different Availability Zones guarantees automatic failover and shared storage replication.
Aurora storage is automatically replicated across three Availability Zones. Failover to an Aurora Replica in another AZ takes less than 30 seconds.
3
Analyze the read scaling requirements.
Determined that read scaling must be dynamic and handled automatically.
By connecting the application to the reader endpoint and configuring Aurora Auto Scaling, instances are provisioned or terminated dynamically to handle load changes.

Key Concept

High Availability and Read Scaling in Amazon Aurora
Rate this question

Topics

Resilient Database Configurations and High Availability

More questions from this topic