Port Exhaustion - SQL

[Maxim Konovalov]

Hi,

On 16/05/2019 16:46, Brandon Mallory wrote:
> This is a very busy server and tried to push our programming
> department to move to persistent connections, they feel that it
> could be a security issue if dealing with sensitive information
> since that connection could be hijacked. We do not have an issue on
> the mysql server side with Port Exhaustion, just on the "Frontend
> webserver".  We have made a lot of changes, and are currently
> managing but I fear that we will reach the 65k limit again. If I
> could get something to load balance LAN interfaces I could double
> the port limitation. I see that haproxy has an article on this, I
> love nginx and use it for other applications but maybe its the wrong
> product for this senerio. I was thinking there might be a way using
> proxy_bind. 
> 
> https://www.haproxy.com/blog/haproxy-high-mysql-request-rate-and-tcp-source-port-exhaustion/
> *

Nothing wrong with nginx in this scenario:

https://www.nginx.com/blog/overcoming-ephemeral-port-exhaustion-nginx-plus/

-- 
Maxim Konovalov