Hi, We are not trying to load balance across our databases. We got simple client - server architecture. Here is the brief description . when the application users logged into the Front End(Client) they do certain actions based on their privileges. When the user does the action the FE connect to the backend process. The backend does all the business logic and send the response back to the FE.
As the user base has increased tremendously, we are planning to run 5 to 10 instance of the backend process and employ the HAProxy load balancer. We want to load balance the requests through the user id and based on the action what he did at the FE. ( The FE sends the user id , action name etc to the backend process). We plan to create to set of backend groups where we want to route the action A & C to group A and action B & D to group B. So we have to scan or read our incoming request in Haproxy and employ the rules to route to different groups based on what action/request the user did in FE. Thank You, Sreeni T Work : +1 781-302-6143 Cell : +1 617-955-3736 sturlap...@statestreet.com -----Original Message----- From: David Birdsong [mailto:david.birds...@gmail.com] Sent: Tuesday, August 17, 2010 6:15 PM To: Turlapati, Sreenivasa Cc: Willy Tarreau; haproxy@formilux.org Subject: Re: 'haproxy' in AIX OS for C++ Applications If you want haproxy to load balance across your databases and do so by some value in the traffic, you'll need to expose your database via a protocol that haproxy supports. Write an RPC service that speaks HTTP and have haproxy load balance across your RPC servers using HTTP values. This is pretty common practice IMHO. On Tue, Aug 17, 2010 at 2:16 PM, Turlapati, Sreenivasa <sturlap...@statestreet.com> wrote: > Thxs a lot. > > Sorry, if I am misguiding you. > > I am just curious to know, when HAProxy is set at TCP mode, we want to > scan or glance over the incoming request for a particular string say > 'XYZ'. If the incoming request contains the 'XYZ' string, route the > request to a backend xyz group else route to backend 'ABC' group. > > Thank You, > Sreeni T > Work : +1 781-302-6143 > Cell : +1 617-955-3736 > sturlap...@statestreet.com > > -----Original Message----- > From: Willy Tarreau [mailto:w...@1wt.eu] > Sent: Tuesday, August 17, 2010 4:16 PM > To: Turlapati, Sreenivasa > Cc: haproxy@formilux.org > Subject: Re: 'haproxy' in AIX OS for C++ Applications > > On Tue, Aug 17, 2010 at 03:50:19PM -0400, Turlapati, Sreenivasa wrote: >> Hi, >> >> We are not trying to use sql proxy, indeed we are using the TCP proxy. >> >> Just we need to read the incoming request and based on the sql file > name >> we need to route the request to a backend server. We doesn't need to >> bother what the sql file got and how to execute it, we need to care >> which group we need to route the request. > > I understand what you want to do, but you have to understand that > "the sql file name" designates something which does not exist at the TCP > level. This means that an SQL parser is required to be able to extract > that > from the requests, and in my opinion the best way to find one is to > check > an SQL proxy. > > Regards, > Willy > > >
