Re:Serverless: A lesson learned the hard way
by voganmother42 on Thursday August 10, 2017 @06:19PM
(#14984879)
One solution, use external pooler like pgbouncer or mysql-proxy running on a small instance(s)
Re:Serverless: A lesson learned the hard way
by orthecreedence on Thursday August 10, 2017 @08:46PM
(#14985750)
I'm actually kind of blown away RDS doesn't have pgbouncer installed on the database. That's how we operate...each db server has pgbouncer living right on it. We connected to bouncer, not directly to the DB.
My main challenge with serverless is using Lambda with API Gateway. Lambda has no database connection pooling, so I end up with a ridiculous number of connections to RDS - one for each simultaneous user. I haven't found a solution to this yet, other than not using API Gateway.