Hi,
I want to load balance a postgres server on 4 physical machines, say
127.0.0.11-14. I can set up a pgbouncer on 127.0.0.10 and connection pooling
to my four boxes. However, the traffic from/to clients will go through an
extra hop. Another way to do this, is to send the client an "redirect"
message. When client connect to 127.0.0.10, instead of accepting the
connection, it can reply to client telling it to reconnect to one of the server
on 127.0.0.11-14.
I am planning to write/submit a patch to do that. I wonder if there is similar
effort in extending libpq protocol, or, if you have better ideas on how to
achieve this.
Thank you,
Feng
_________________________________________________________________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with
Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
