Maximizing value of max connections in AWS RDS

Question

Where can I find the highest value of max_connections in AWS RDS?

Answer 1

You have it in the console. You should have:

• 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

Refer this for more info: http://tritoneco.com/2015/11/23/max_connections-at-aws-rds-mysql-instance-sizes/

Answer 2

Here is the Chart I made telling you those per-Server Model limits

MODEL      max_connections innodb_buffer_pool_size
---------  --------------- -----------------------
t1.micro   34                326107136 (  311M)
m1-small   125              1179648000 ( 1125M,  1.097G)
m1-large   623              5882511360 ( 5610M,  5.479G)
m1-xlarge  1263            11922309120 (11370M, 11.103G)
m2-xlarge  1441            13605273600 (12975M, 12.671G)
m2-2xlarge 2900            27367833600 (26100M, 25.488G)
m2-4xlarge 5816            54892953600 (52350M, 51.123G)

Answer 3

AWS RDS Max Connections Limit As Per Instance Type
 

AWS sets the MySQL max connections system varies according to the size of the RDS instance.  A “Too many connections” error message may be displayed if this is reached.

Maximum Database Connections Chart

DB Engine	Parameter	Allowed Values	Default Value
MariaDB and MySQL	max_connections	1–100000	{DBInstanceClassMemory/12582880}
Oracle	processes	80–20000	LEAST({DBInstanceClassMemory/9868951}, 20000)
	sessions	100–65535	–
PostgreSQL	max_connections	6–8388607	LEAST({DBInstanceClassMemory/9531392}, 5000)
SQL Server	Maximum number of concurrent connections	0–32767	0 (unlimited)