SOA-C02 · Question #465
A company is running production workloads that use a Multi-AZ deployment of an Amazon RDS for MySQL db.m6g.xlarge (general purpose) standard DB instance. Users report that they are frequently…
The correct answer is C. Configure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint. The "too many connections" error indicates that the Amazon RDS for MySQL DB instance is reaching its maximum allowed connections, causing users to encounter issues. RDS Proxy is a highly recommended solution to manage database connections and improve scalability and By…
Question
A company is running production workloads that use a Multi-AZ deployment of an Amazon RDS for MySQL db.m6g.xlarge (general purpose) standard DB instance. Users report that they are frequently encountering a "too many connections" error. A SysOps administrator observes that the number of connections on the database is high. The SysOps administrator needs to resolve this issue while keeping code changes to a minimum. Which solution will meet these requirements MOST cost-effectively?
Options
- AModify the RDS for MySQL DB instance to a larger instance size.
- BModify the RDS for MySQL DB instance to Amazon DynamoDB.
- CConfigure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint.
- DModify the RDS for MySQL DB instance to a memory optimized DB instance.
How the community answered
(22 responses)- A14% (3)
- B5% (1)
- C77% (17)
- D5% (1)
Explanation
The "too many connections" error indicates that the Amazon RDS for MySQL DB instance is reaching its maximum allowed connections, causing users to encounter issues. RDS Proxy is a highly recommended solution to manage database connections and improve scalability and By implementing RDS Proxy and updating the application's configuration to use the proxy endpoint, you can effectively manage connections and alleviate the "too many connections" issue without making significant code changes.
Topics
Community Discussion
No community discussion yet for this question.