Re: hundreds of backends, one for each client

2012-10-14 Thread Willy Tarreau
Hi Jones,

On Sat, Oct 13, 2012 at 06:48:11PM -0700, Allteams Jones wrote:
 Hi,
 
 I'm trying to find the best way to proxy a few thousand TCP clients and make
 sure each one connects to their own backend server. Essentially I have a few
 hundred DB servers and each one of them belongs to a single client. I want to
 have a single HAProxy server and based on the destination TCP port, use the
 appropriate backend. Those connections need to be persistent and security is
 not an issue (DB authenticates client). What is the best way to go about
 this? Should I define a few thousand ACLs or define a separate section for
 each port-DB mapping?

What you describe sounds exactly like the simplest relaying configuration :
  - defaults section for all common settings (mode tcp, timeouts, ...)
  - one listen section with bind for the listening port and server
for the server, per client.

It also has the benefit of being more debuggable and observable (eg: think
about the stats).

Hoping this helps,
Willy




hundreds of backends, one for each client

2012-10-13 Thread Allteams Jones
Hi,

I'm trying to find the best way to proxy a few thousand TCP clients and make 
sure each one connects to their own backend server. Essentially I have a few 
hundred DB servers and each one of them belongs to a single client. I want to 
have a single HAProxy server and based on the destination TCP port, use the 
appropriate backend. Those connections need to be persistent and security is 
not an issue (DB authenticates client). What is the best way to go about this? 
Should I define a few thousand ACLs or define a separate section for each 
port-DB mapping?

Thank you for your help,
Jones