Examkin

Question

Difficulty: EasyPerformance and Scalability Optimization

An application's database is deployed on a single Amazon RDS for MySQL Multi-AZ DB instance. Monitoring metrics indicate that high read latency during business hours is causing performance degradation, while write latency remains low. Which two actions should a solutions architect take to scale the database layer and improve query response times?

  1. Create Amazon RDS Read Replicas and update the application to route read traffic to the replica endpoints.Answer
  2. Deploy an Amazon ElastiCache cluster to store the results of common read queries.Answer
  3. C
    Configure the application to query the standby instance of the RDS Multi-AZ deployment to distribute the read load.
  4. D
    Submit a request to AWS Support to pre-warm the primary RDS DB instance prior to peak business hours.
  5. E
    Deploy an Amazon ElastiCache for Memcached cluster to enable multi-AZ database replication and transaction persistence.

Answer

To scale the database layer for read-heavy workloads, a solutions architect should create Amazon RDS Read Replicas to offload read operations and deploy an Amazon ElastiCache cluster to cache frequently accessed query results.
The correct actions are implementing RDS Read Replicas and deploying ElastiCache. Creating RDS Read Replicas allows horizontal scaling of read operations by routing read traffic away from the primary database. Implementing an Amazon ElastiCache cluster caches frequent query results, reducing the round-trip latency to the database and saving DB CPU cycles.

Step-by-Step Solution

1
Analyze the application performance metrics and workload characteristics.
Identify that the primary performance bottleneck is high read query latency, while write latency remains low, indicating a read-heavy workload.
Understanding the nature of the workload (read-heavy vs. write-heavy) determines the correct scaling strategy.
2
Evaluate potential scaling solutions for Amazon RDS read traffic.
Select read replicas to offload read traffic horizontally, and caching (ElastiCache) to store frequently accessed data in-memory.
RDS Read Replicas and ElastiCache are the standard, operationally efficient AWS patterns for scaling read operations on RDS MySQL.

Key Concept

Scaling read capacity for Amazon RDS databases using Read Replicas and caching.
Estimated Time:1m 0s
Rate this question

Topics

Performance and Scalability Optimization

More questions from this topic