Archive

Posts Tagged ‘aws aurora’

AWS RDS Aurora max_connections limit

February 15th, 2018 No comments

For our office products, we are using Amazon Cloud. For the database, we prefer to use Amazon RDS (Aurora). Recently one of our sites was showing lots of error message in sentry.io. The error log shows it was because of MySQL denied to connect for too many open connections. This is when we checked the RDS max_connection limit and found its related to the size of your RDS instance. So we tested the max_connection limit for different size instances. And here is the result:

t2.small:

aurora max connection limit small 45

t2.medium:

aurora max connection limit medium 90

r3.large:

aurora max connection limit large 1000

r3.xlarge:

aurora max connection limit xlarge 2000

r3.2xlarge:

aurora max connection limit 2xlarge 3000

r3.4xlarge:

aurora max connection limit 4xlarge 4000

r3.8xlarge:

aurora max connection limit 8xlarge 5000

57 queries in 0.103 seconds