Examkin

Soru

Zorluk: OrtaImproving Database and Caching Efficiency

A sports media company runs a live game-tracking application that uses an Amazon RDS for MySQL Multi-AZ DB instance as its data store. During major tournaments, the application experiences a surge in read traffic, with users frequently querying match statistics that do not change often. This read traffic causes the database CPU utilization to exceed 80%80\%, resulting in latency and connection timeouts. The architecture requires a highly available caching layer that supports replication to offload read traffic and reduce database latency. Which TWO actions should the Solutions Architect take to optimize database and caching efficiency while meeting these requirements? (Select TWO.)

  1. Deploy an Amazon ElastiCache for Redis replication group with Multi-AZ and automatic failover enabled, and configure the application to cache frequently queried statistics.Cevap
  2. Create Amazon RDS read replicas and update the application to route read-only queries for match statistics to the read replica endpoints.Cevap
  3. C
    Deploy an Amazon ElastiCache for Memcached cluster and configure multi-AZ replication to cache the statistics.
  4. D
    Configure the application to route read queries to the standby instance of the Amazon RDS MySQL Multi-AZ deployment during peak hours.
  5. E
    Implement an Application Load Balancer in front of the Amazon RDS MySQL DB instance and request pre-warming to handle the read query spikes.

Cevap

To optimize database and caching efficiency, the Solutions Architect should deploy an Amazon ElastiCache for Redis replication group with Multi-AZ and automatic failover to cache frequently queried statistics, and create Amazon RDS read replicas to offload read-heavy query traffic from the primary database instance.
Deploying an Amazon ElastiCache for Redis replication group with Multi-AZ and automatic failover, combined with creating Amazon RDS read replicas, represents the optimal solution. ElastiCache for Redis offloads repeat queries for static match statistics using a highly available, replicated caching layer. Read replicas offload general read query traffic from the primary database instance, reducing CPU utilization.

Adım Adım Çözüm

1
Analyze database performance metrics and bottleneck root cause.
Identify that the database CPU bottleneck is driven by high read volume for mostly static data during tournaments.
Determining the query patterns helps distinguish between write-heavy and read-heavy performance issues.
2
Evaluate caching solutions against high availability and replication requirements.
Select Amazon ElastiCache for Redis because it supports replication, Multi-AZ failover, and persistence, whereas Memcached does not.
The requirement explicitly demands replication support and high availability in the caching layer.
3
Configure read replication for database-level offloading.
Deploy Amazon RDS read replicas to absorb queries that cannot be served by the cache, routing them away from the primary DB instance.
Directing read traffic to replicas reduces the processing load on the primary DB instance, lowering CPU utilization.

Anahtar Kavram

Offloading read-heavy workloads from relational databases using a combination of high-availability caching tiers and read replicas.
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

Improving Database and Caching Efficiency