MySQL connection limit planning
MySQL connection limits are derived from instance memory unless you override max_connections in the parameter group. Plan pools per pod so total needed connections stay within usable capacity.
Example: usable connections of 900 with 10 pods yields 900 ÷ 10 = 90 per pod. Reduce pool size if you plan to scale above 10 pods.
FAQs
Is the default always safe? Not necessarily. Defaults do not account for your pod count or burst traffic.
Should I use a proxy? Consider it if you need aggressive pooling or workload multiplexing.
Do I need reserved connections? Yes. Keep some capacity for operational work and maintenance windows.
Open the preset
Use this preset to model a typical MySQL app-side pool.
Open calculator with this preset