Question
Connection pooling is not supported?
- Posted on November 19, 2019
- MySQLDigitalOcean Managed MySQL Database
Asked by eparry
I just want to make sure I read that correctly, pooling is not supported by your managed Mysql instances?
https://www.digitalocean.com/docs/databases/mysql/
Does this mean I can only have a single connection from my servlet container? That would definitely be a deal breaker for a production system.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Get our biweekly newsletter
Sign up for Infrastructure as a Newsletter.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.
Become a contributor
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Hello,
Connection pooling is just a specific technique in handling connections, it means that connections are reused rather than created each time a connection is requested.
Connection pooling is different from
max_connectionsin MySQL, so this means that you could still have multiple connections from your server to your Database cluster.Hope that this helps. Regards, Bobby
So it’s on the server side, not the client side. Ok, that makes sense. I would clarify that in the docs as it could scare off devs like myself who are considering moving to a managed db.