[pgpool-general: 2990] Re: Apps Server configuration ?
Yugo Nagata
nagata at sraoss.co.jp
Mon Jun 30 19:30:21 JST 2014
Hi,
pgpool-II works as like "proxy" of PostgreSQL. This means, pgpool-II
looks like a client from PostgreSQLs and looks like a PostgreSQL server
from your appliction.
[application] <-> [pgpool-II] <-> [PostgreSQL(s)]
So, you don't need to change so many code of your apps.
However, please note that pgpool-II some restrictions. For example,
pgpool-II cannot process multi-statement queries.
http://www.pgpool.net/docs/latest/pgpool-en.html#restriction
On Fri, 27 Jun 2014 08:53:01 -0430
Luis Marin <luismarinaray at gmail.com> wrote:
> Hi,
>
> newbie question:
>
> As implementer of pgpool, what should I tell to my internal developers
> group, what can we expect from moving our applications from one server with
> apache, postgresql and apps to a pgpool architecture with variable number
> of servers, I'm thinking that 'failover' is a good feature that we could
> benefit, but I'm afraid that they have to change a lot of code, so isn't
> feasible to use pgpool in a very short time, this idea is difficult to
> grasp from me, or I'm wrong and apps does not need any major changes.
>
> Any clarifyng idea is welcome
>
> Thanks
--
Yugo Nagata <nagata at sraoss.co.jp>
More information about the pgpool-general
mailing list