Otdfbt

RDS server come up with 40 connection max, as in the following documentation

I am using Magento 1.9, and at some points, i reach the max number then website is out of service.

Do you have any recommended way to solve this issue?

From my understanding, if i have 2 web servers connection to an RDS server.. then I should have 2 RDS connections, not more.

AWS RDS max_connections limit variable is based on Instance type, so you can upgrade your RDS or make more replica.

The RDS types with max_connections limit:

• t2.micro 66


• t2.small 150


• m3.medium 296


• t2.medium 312


• m3.large 609


• t2.large 648


• m4.large 648


• m3.xlarge 1237


• r3.large 1258


• m4.xlarge 1320


• m2.xlarge 1412


• m3.2xlarge 2492


• r3.xlarge 2540

Referring by max_connections at AWS RDS MySQL Instance Sizes in 2015

Update 2017-07

The current RDS MySQL max_connections setting is default by DBInstanceClassMemory/12582880, if you use t2.micro with 512MB RAM, the max_connections could be (512*1024*1024)/12582880 ~= 40, and so on.

Each Web server could have many connections to RDS, which depends on your SQL requests from Web server.

You can change the max_connections value by either updating the default parameter policy or create a new one - I'd suggest going with the latter.

• Go to RDS


• Parameter Groups


• Create a new Parameter Group (AWS wil leave everything as default)


• search for the max_connections value


• Change the value to use


• Go to RDS instance and modify


• Select new Parameter group created and restart the instance or let AWS reboot it during next maintenance window

Hope this helps!

While increasing the max connections on the server config may fix the problem, you should consider verifying your application configurations and implementations.

I'm not an expert on Magento, but as I recently had a similar issue on a project I was working on, I noticed that the default implementation of the framework I was using created a connection with every call to the database.

While that may not cause any problems to some, the moment you have more visitors or some tasks that are database intensive and can run on multiple connections, the best way to prevent the server crashing with "TOO MANY CONNECTIONS" error is to implement a database connection pool.

This prevents the application from creating more connections that the server can handle, and not crashing the application to the users. A connection pool would keep a queue for the requests to access the database until a connection becomes available so it can proceed with processing the users request.

Just keep in mind that the connection pool should be thread safe in a multi thread scenario.

Login to your RDS instance (using a MySQL client) and run the following query:

SHOW VARIABLES LIKE 'max_connections';

That's not 40 connections max, that is 40 RDS instances max. You are most likely only using 1 instance based on your description.

You can have thousands of connections to the RDS server because each time a session is opened with the database, that creates a new connection. You are probably running into performance constraints and should look into making the RDS instance larger.