Welcome! Log In Create A New Profile

Advanced

RE: Port Exhaustion - SQL

Reinis Rozitis
May 16, 2019 09:36AM
> Yes all of those changes you have mentioned have been made.

Well imo there is nothing else besides to even more decrease the FIN timeout (in a LAN that shouldn't be an issue (no slow clients)) so the lingering sockets are closed faster.

Also instead of adding the network adapter(s) on the webserver you should add the interfaces on the mysql server and then either via loadbalancer or on application level use a round robin fashion (as binding to a specific local interface is harder than just connect to a different remote ip).


Other than that depending on the application you might want to consider using persistent connections to MySQL or use some kind of mysql proxy between which could pool the connections to the mysql server.

rr

_______________________________________________
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: 292
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready