A financial services company runs a reporting application on AWS. The application uses an Amazon Aurora MySQL database cluster with one primary writer instance. The application workload is highly read-intensive, with a predictable increase in read queries during the final three days of each month. The write query volume remains low and constant. The solution must dynamically scale the read capacity to maintain query latencies under while minimizing costs during periods of low activity.
Which database scaling strategy should a solutions architect recommend?
- Configure Amazon Aurora Auto Scaling to dynamically scale Aurora Replicas based on CPU utilization, and direct the application's read traffic to the Aurora reader endpoint.Cevap
- BEnable Amazon RDS Multi-AZ deployment, and configure the reporting application's queries to read directly from the standby database instance during peak periods.
- CDeploy an Application Load Balancer in front of the database cluster to distribute read queries, and request load balancer pre-warming from AWS Support three days prior to the peak.
- DDeploy an Amazon ElastiCache for Memcached cluster to cache reporting query results, and configure Multi-AZ replication to ensure persistence during failovers.
Cevap
Configure Amazon Aurora Auto Scaling to dynamically scale Aurora Replicas based on CPU utilization, and direct the application's read traffic to the Aurora reader endpoint.
The correct strategy leverages Amazon Aurora Auto Scaling to dynamically provision Aurora Replicas as read load increases. Aurora Replicas share the same storage volume as the primary instance, meaning scaling operations are fast and do not duplicate storage. Directing read traffic to the reader endpoint automatically load balances queries across all active replica instances.
Adım Adım Çözüm
Anahtar Kavram
Horizontal Read Scaling with Amazon Aurora Replicas and Auto Scaling
Tahmini Süre:2m 0s