Re: Does anyone user pg-pool II on real production ? Please help me.

Thanks for all.

I will try pgpool-II & pgbouncer . Hope it is good solution.

Tuan Hoang Anh

On Wed, Jan 7, 2015 at 8:30 AM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
wrote:

>
> On 6 Jan 2015 03:02, "tuanhoanganh" <hatuan05(at)gmail(dot)com> wrote:
> >
> > Hello everybody
> >
> > Does anyone user pg-pool II on real production ?
>
> Yes we have a customer using it in load balancing mode and another one
> using it with Watchdog for high availability.
>
> > How many slave do you have? and how many size of database ?
> >
>
> In both cases 1. But I believe pgpool can support more databases. Size of
> db should not matter but we have 50GB if database being used with pgpool.
>
> > I need config my old retail system to support ~ 1500 user with 1000GB
> over 4 years. I want to try pgpool-II but don't found real system use it.
> >
>
> I guess in addition to using pgpool you should also think about using
> pgbouncer as connection pooling agent (I would probably install it on
> application server and configure to connect to pgpool)
>
> > My system use direct SQL SELECT query and a lot pg procedure.
>
> If there is a way you can specify different connection strings for these
> two type of queries then you can make most out of pgbouncer. Do you do any
> explicit transactions in these procedures?
>
> > Can pgpool-II support load balance from SELECT my_procedure() ...
>
> Yes you can specify those on white list (provided they are readonly
> procedures).
>
> >
> > Please help me
> >
> > Thanks in advance. Sorry for my English.
>