Welcome! Log In Create A New Profile

Advanced

Port Exhaustion - SQL

CCS
May 16, 2019 08:53AM
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.

Webserver
192.168.99.17
192.168.99.21

MYSQL Server
192.168.99.19

Can anyone help with a config that would accomplish splitting the connection from 192.168.99.17 -> 192.168.99.19 with a second lan adapter (192.169.99.21).

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

Any help or advice would be appreciated.

Thanks
Brandon
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: 96
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