SAA-C03 Question 301
Single answerYour company has a web application hosted on Amazon ECS that connects to an Amazon RDS MySQL database. The application occasionally experiences connection issues under heavy traffic due to too many open connections to the database. How can you resolve this issue in a cost-effective and scalable way?
- A
Increase the instance size of the RDS database to handle more connections.
- B
Use Amazon RDS Proxy to manage the database connections efficiently.
- C
Implement connection pooling in the application code to limit the number of open connections.
- D
Enable Multi-AZ deployment for the RDS database to improve availability.
Show answer and explanation
Correct answer: B
Explanation
Amazon RDS Proxy is a managed service that sits between your application and the RDS database, pooling and sharing connections to efficiently handle traffic spikes. It reduces the overhead of managing connections and is a scalable, cost-effective solution for this scenario.
- A. Incorrect.
Increasing the instance size can temporarily alleviate the issue, but it is not cost-effective or scalable for connection management. The problem lies in managing connections, not the database's compute capacity.
- B. Correct.
Amazon RDS Proxy is specifically designed to manage database connections efficiently by pooling and sharing connections, which reduces the risk of overloading the database during traffic spikes.
- C. Incorrect.
While connection pooling in the application code can help, it requires significant development effort and ongoing maintenance. A managed service like RDS Proxy is a more scalable and cost-effective solution.
- D. Incorrect.
Multi-AZ deployment improves database availability and failover capabilities but does not address connection management issues.