BLOG_AMAZON

RDS MySQL Connection Limits by AWS Instance Type

The RDS Connection Calculation Problem

When using Amazon Web Services’ RDS MySQL service on the back end of clusters of web servers, one resource constraint that can occur in times of heavy load is database connection starvation.

Planning capacity in the RDS MySQL layer often comes down to ensuring enough connections are available; avoiding queuing on the web tier for connection releases.

But how do you know how many connections you get from a given instance type?

The Solution

Fortunately there is a useful little calculation to determine connections by instance type:

max_connections={DBInstanceClassMemory/12582880}

That’s 12582880 bytes by the way….

So for example:

RDS Connection Limits by Instance Type

A Large RDS MySQL Instance with 7.5 GB memory has a limit of 640 connections.

You can find more out about the various RDS MySQL instance types at this page. You can feed the memory information listed there into the equation above to work out connection limits for all current RDS instance types.

 

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>