Examkin

Question

Difficulty: EasyDatabase and Storage Strategy

A solutions architect is designing a database strategy for an online application that uses an Amazon RDS for MySQL database. The database experiences sudden spikes in read query volume, which degrades performance. The solutions architect needs to offload this read traffic and allow the database to scale horizontally. Which of the following designs represents the correct and most efficient database strategy to scale read capacity?

  1. A
    Configure Amazon RDS Multi-AZ and direct all read traffic to the standby instance in the secondary Availability Zone.
  2. Migrate the database to Amazon Aurora MySQL and configure Aurora Auto Scaling to dynamically scale the number of Aurora Replicas based on read load.Answer
  3. C
    Deploy Amazon ElastiCache for Memcached, enabling its persistence and multi-AZ replication features to store and serve the relational query results.
  4. D
    Implement a secondary database in another AWS Region using a pilot light disaster recovery model to handle the read query spikes.

Answer

Migrate the database to Amazon Aurora MySQL and configure Aurora Auto Scaling to dynamically scale the number of Aurora Replicas based on read load.
Migrating to Amazon Aurora MySQL allows the architecture to utilize Aurora Replicas, which are active and capable of serving read traffic. By enabling Aurora Auto Scaling, the system can automatically adjust the number of replicas to handle dynamic changes in read demand, ensuring application performance and cost efficiency.

Step-by-Step Solution

1
Analyze the workload requirements
The requirement is to scale read capacity horizontally and handle sudden read spikes dynamically.
This helps determine which replication and auto-scaling mechanisms are valid.
2
Evaluate the database replication options
Amazon RDS Multi-AZ standbys cannot serve read traffic. Amazon Aurora Replicas can serve active read traffic and support dynamic auto-scaling.
This filters out strategies that cannot offload read queries.
3
Select the correct caching and scaling configuration
Aurora Auto Scaling with Aurora Replicas is selected because it meets the horizontal scalability requirement natively, whereas ElastiCache for Memcached lacks persistence and replication support.
This establishes the most efficient and architecturally sound database design.

Key Concept

Scaling database read capacity using Amazon Aurora Replicas and Aurora Auto Scaling.
Rate this question

Topics

Database and Storage Strategy

More questions from this topic