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.
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_connections in MySQL, so this means that you could still have multiple connections from your server to your Database cluster.
Hope that this helps. Regards, Bobby
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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.