Port Exhaustion - SQL

CCS nginx-forum at forum.nginx.org
Thu May 16 12:53:22 UTC 2019

I have recently moved our sql server off of our webserver and now we are
experiencing Port Exhaustion. We have made all the changed we could in the
kernel to help with this but still hitting limits. I have added a 2nd
virtual network adapter, I am now trying to "load balance" the lan
connection between our web server and mysql server port 3306.


MYSQL Server 

Can anyone help with a config that would accomplish splitting the connection
from -> with a second lan adapter

These are local connections so spiting by remote IP is not an option. I just
want say half of the connections that go to use port from and half to use ports from 

Any help or advice would be appreciated. 


Posted at Nginx Forum: https://forum.nginx.org/read.php?2,284187,284187#msg-284187

More information about the nginx mailing list