Answer-first summary for fast verification
Answer: Migrate the database to Amazon Aurora, and add an Aurora Replica Configure Amazon RDS Proxy to manage database connection pools
Migrating the database to Amazon Aurora and adding an Aurora Replica improves scalability, performance, and availability. Aurora is designed with enhanced integration and compatibility with MySQL, providing high performance and reliability benefits over standard MySQL. Adding an Aurora Replica helps to distribute read traffic, thus reducing the load on the primary instance. Additionally, AMAZON RDS Proxy is crucial because it efficiently manages large volumes of concurrent connections to the database by pooling and reusing existing database connections. This connection pooling improves the scalability and availability of the database by reducing the overhead of opening and closing new connections and minimizing the impact of high numbers of concurrent users. This approach addresses the issue of slow response times during peak periods caused by too many simultaneous connections. Therefore, option D is the correct solution as it combines Aurora's scalability and performance enhancements along with RDS Proxy's connection management capabilities to meet the requirements.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company runs a software-as-a-service (SaaS) application on AWS. The application consists of AWS Lambda functions and an Amazon RDS for MySQL Multi-AZ database. During market events the application has a much higher workload than normal Users notice slow response times during the peak period because of many database connections. The company needs to improve the scalable performance and availability of the database. Which solution meets these requirements?
A
Create an Amazon CloudWatch alarm action that triggers a Lambda function to add an Amazon RDS for MySQL read replica when resource utilization hits a threshold
B
Migrate the database to Amazon Aurora, and add a read replica Add a database connection pool outside of the Lambda handler function
C
Migrate the database to Amazon Aurora, and add a read replica Use Amazon Route 53 weighted records
D
Migrate the database to Amazon Aurora, and add an Aurora Replica Configure Amazon RDS Proxy to manage database connection pools
No comments yet.