Which solution will meet these requirements MOST cost-effectively?

By:
In: DBS-C01
Tagged:
With: 2 Comments
A company needs to troubleshoot its Amazon Aurora Serverless MySQL database.The company selected a db.t3, medium instance class for the database’s initial deployment.The database experienced light usage, and performance was normal.As the number of client connections increases, the application that is connected to the database is experiencing higher latency and occasional lost connections.A database specialist determines that the database needs to support a maximum of 2,000 simultaneous connections.

Which solution will meet these requirements MOST cost-effectively?

Modify the instance class to db.r3.xlarge. Apply the changes immediately.

Edit the default parameter group for the MySQL engine that the database uses. Change the max_connections value to 2,000. Reboot the DB instance to apply the new value.

Create a new parameter group for the MySQL engine that the database uses. Set the max_connections value to 2,000. Assign the parameter group to the DB instance. Apply the changes immediately.

Modify the instance class to db.t3.large. Apply the changes immediately.

Explanations:

The db.r3 instance class is not supported in Amazon Aurora Serverless, which auto-scales resources dynamically. Moving to db.r3.xlarge will not resolve issues with connection limits or cost-effectiveness, as db.r3 instances are older and intended for provisioned setups.

Editing the default parameter group to increase max_connections to 2,000 is not ideal. Adjusting this parameter alone does not guarantee the Aurora Serverless cluster will have enough resources to handle 2,000 connections, and modifying the default parameter group can impact other databases using it.

Creating a new parameter group and setting max_connections to 2,000 is the best solution. It allows Aurora Serverless to scale to meet the connection requirements without modifying default settings. Applying a custom parameter group ensures dedicated configurations for this database alone, meeting the 2,000 connections requirement efficiently.

Modifying the instance class to db.t3.large does not resolve the issue, as the db.t3 instance family is not optimized for higher connection limits. The issue is not about instance size but configuring Aurora Serverless to handle more connections.

2026-04-06

2 Comments

  1. Brian
    Author

    If I’m not mistaken, the answer is:
    Create a new parameter group for the MySQL engine that the database uses. Set the max_connections value to 2,000. Assign the parameter group to the DB instance. Apply the changes immediately.

  2. Scott
    Author

    I would say the answer is:
    Create a new parameter group for the MySQL engine that the database uses. Set the max_connections value to 2,000. Assign the parameter group to the DB instance. Apply the changes immediately.

Leave a Reply

Your email address will not be published. Required fields are marked *

eight + 18 =