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.ku...@ashnik.com> wrote: > > On 6 Jan 2015 03:02, "tuanhoanganh" <hatua...@gmail.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. >
