Welcome! Log In Create A New Profile

Advanced

Re: Port Exhaustion - SQL

Maxim Konovalov
May 16, 2019 10:18AM
On 16/05/2019 16:51, Maxim Konovalov wrote:
> 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/
>
+ make sure you are not using ancient nginx version. I refer to
this change in 1.11.2 and follow up change in 1.11.4

*) Feature: now nginx uses the IP_BIND_ADDRESS_NO_PORT socket option
when available.

--
Maxim Konovalov
_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx
Subject Author Posted

Port Exhaustion - SQL

CCS May 16, 2019 08:53AM

RE: Port Exhaustion - SQL

Reinis Rozitis May 16, 2019 09:10AM

Re: Port Exhaustion - SQL

CCS May 16, 2019 09:12AM

RE: Port Exhaustion - SQL

Reinis Rozitis May 16, 2019 09:36AM

Re: Port Exhaustion - SQL

CCS May 16, 2019 09:48AM

Re: Port Exhaustion - SQL

Maxim Konovalov May 16, 2019 09:52AM

Re: Port Exhaustion - SQL

CCS May 16, 2019 10:12AM

RE: Port Exhaustion - SQL

Reinis Rozitis May 16, 2019 10:40AM

Re: Port Exhaustion - SQL

CCS May 16, 2019 11:14AM

Re: Port Exhaustion - SQL

Maxim Konovalov May 16, 2019 10:18AM

RE: Port Exhaustion - SQL

Reinis Rozitis May 16, 2019 10:16AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 77
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready