I am trying to decide which AWS RDS instance type is to be used.
I have the stats of the number of database connections required by the application.
Is it possible to know which AWS RDS instance type supports how many database connections approximately?
I have the following list with me, but I'm not sure how accurate it is to date:
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
Is there any official AWS document for the same?
Best Answer
You can also verify the
max_db_connection
valueor
Click on the default Parameter Group and search for max_connections and you’ll see the formula. In my case, it’s
{DBInstanceClassMemory/magic_number}
.But the numbers in the
max_connections
column look slightly awkward because they are actually calculated from a formulaDBInstanceClassMemory/magic_number
where magic_number differs according to the class of your instance.You can check this link for updated documentation MySQL Managing Performance.
It's mean the higher the memory, the instance will capable to handle more connection. you check DB instance class size here.
Choose RDS class.