# Connection Pooling
⚠ Work in Progress ⚠️
There's more to document here. In the meantime, you can check our community forum for answers.
Want to contribute? Redwood welcomes contributions and loves helping people become contributors. You can edit this doc here. If you have any questions, just ask for help! We're active on the forums and on discord.
Production Redwood apps should enable connection pooling in order to properly scale with your Serverless functions.
All new Supabase projects include connection pooling using PgBouncer.
For Postgres, see Postgres Connection Pooling.
Heroku does not officially support MySQL.
# Digital Ocean
For Postgres, see How to Manage Connection Pools
Connection Pooling for MySQL is not yet supported.
Use Amazon RDS Proxy for MySQL or PostgreSQL.
From the AWS Docs:
Your RDS Proxy must be in the same VPC as the database. The proxy can't be publicly accessible.
Because of this limitation, with out-of-the-box configuration, you can only use RDS Proxy if you're deploying your Lambda Functions to the same AWS account. Alternatively, you can use RDS directly, but you might require larger instances to handle your production traffic and the number of concurrent connections.
# Why Connection Pooling?
Relational databases have a maximum number of concurrent client connections.
- Postgres allows 100 by default
- MySQL allows 151 by default
In a traditional server environment, you would need a large amount of traffic (and therefore web servers) to exhaust these connections, since each web server instance typically leverages a single connection.
In a Serverless environment, each function connects directly to the database, which can exhaust limits quickly. To prevent connection errors, you should add a connection pooling service in front of your database. Think of it as a load balancer.