[Pgpool-general] Suggestion for load_balancing mode

[Josh Berkus]

Tatsuo,

> What I want to do by "session level load balancing" is something like
> this:
>
> 1) a client which is willing to use session level load balancing
>    explicitly declare it by issuing a special command or set global
>    parameter in pgpool.conf
>
> 2) when the client connects to pgpool, pgpool selects one of the two
>    servers to deal with the client.
>
> 3) the client sends SQL to pgpool and pgpool forwards it to the
>    selected PostgreSQL server
>
> 4) repeat 3) until the client disconnects

Makes sense to me.   Actually, this is how a lot of other pooling mechanisms 
(like Hibernate) work.   Except they don't have the option *not* to maintain 
a session.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco