Website which is hosted on AWS not working due to limitation of database connections.

Raghavendra Seshumurthy

Issue:

Users are getting below error when they browse website which is hosted on AWS.

Could not connect to the database: SQLSTATE [HY000] [1040] too many connections.

Root Cause:

AWS RDS database has Database connection limitations.

Solution:

  1. Increase the database connection limit.
  2. Login to AWS management console.
  3. Go to RDS > Parameter groups > Select your database parameter group name
  4.  Select and edit max_connections parameter.
  5. Change the value according to your requirement.
  6. You can also upgrade your instance to next gen instance type based on your requirement.

Default Values for RDS instances:

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 254

 

 

 

 

Published by Raghavendra Seshumurthy

My name is Raghavendra Seshumurthy. Presently I am working as a technolgy manager for Microland Organization. I have experience on security/cloud products: F5, Checkpoint, ASA, PA, AWS, Bluecoat, VPN, PITC, Zscaler, Azure, GCP, network, security, cloud. This blog is created just to share thoughts on new technologies and features in the network, security and cloud environment.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s