Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
22.75k stars 1.57k forks source link

Allow self-host users to enable connection pooling for plus datasources #6130

Open PClmnt opened 2 years ago

PClmnt commented 2 years ago

Feature Request We can't enable this in cloud due to performance issues, but we should allow self-hosting users to enable connection pooling for plus datasources.

COS

aderici commented 2 years ago

Also needed for Azure appservice users because outbound ports are limited and frequently opening and closing connections cause errors when there's a lot of demand. (many webapps in the same infrastructure sharing the same outbound ip, trying to connect to same azure mysql service inboing ip, there's only 65535 ports available)

Link to azure doc that suggests using connection pooling : https://docs.microsoft.com/en-us/azure/app-service/troubleshoot-intermittent-outbound-connection-errors

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity.