AWS Certified SysOps Administrator – Associate — Question 270

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?

Answer options

• A. Modify the RDS for MySQL DB instance to a larger instance size.
• B. Modify the RDS for MySQL DB instance to Amazon DynamoDB.
• C. Configure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint.
• D. Modify the RDS for MySQL DB instance to a memory optimized DB instance.

Correct answer: C

Explanation

Amazon RDS Proxy establishes a database connection pool, allowing many application connections to share a smaller pool of database connections, effectively resolving the 'too many connections' error. This solution is highly cost-effective compared to upgrading the DB instance size (Options A and D) and only requires modifying the database endpoint in the configuration file. Migrating to DynamoDB (Option B) would require extensive code rewriting, violating the minimal code changes requirement.