A solutions architect is designing a high-performance database strategy for a new relational OLTP workload. The application requires highly available database access across multiple Availability Zones and must dynamically scale horizontally to handle unpredictable spikes in read traffic.
Which two strategies should the solutions architect implement to meet these requirements?
- Deploy an Amazon Aurora MySQL database cluster with Aurora Replicas to scale read workloads.Answer
- Configure Aurora Auto Scaling to dynamically adjust the number of Aurora Replicas based on CPU utilization.Answer
- CDeploy an Amazon RDS for MySQL database in a Multi-AZ configuration and direct read traffic to the standby instance to handle peak loads.
- DSet up a single-node Amazon RDS for MySQL database and configure AWS KMS managed keys (aws/rds) to encrypt cross-account read replicas.
- EDeploy an Amazon RDS for MySQL database with a Multi-Region active-active configuration using pilot light disaster recovery to achieve near-zero RTO and RPO.
Answer
To meet the requirements, the solutions architect should deploy an Amazon Aurora MySQL database cluster with Aurora Replicas and configure Aurora Auto Scaling to dynamically adjust the number of replicas based on CPU utilization.
Deploying an Amazon Aurora MySQL database cluster with Aurora Replicas allows the architecture to scale read workloads by directing queries to reader endpoints. When combined with Aurora Auto Scaling, the database cluster can dynamically add or remove replicas based on target metrics like average CPU utilization, ensuring the application handles sudden peaks in traffic efficiently.
Step-by-Step Solution
Key Concept
Amazon Aurora horizontal read scaling and dynamic replica scaling capabilities.
Estimated Time:1m 30s