Forum OpenACS Development: Re: Postgres9, OpenACS and load balancing

Collapse
3: Re: Postgres9, OpenACS and load balancing (response to 1)
Posted by Maurizio Martignano on 03/29/11 03:45 PM
Dear Augustin,
I had a look at this table:
http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling
It seems pgpool could be (COULD BE) the way to go.
On top of that by using a middleware in between the client and the server(s) you don't need to change your client code.
I was just wondering if somebody had already used pgpool and with which results...
Thanks,
Maurizio
Collapse
4: Re: Postgres9, OpenACS and load balancing (response to 3)
Posted by Eduardo Santos on 03/29/11 06:43 PM
Hi Maurizio,

I also use PgPool mre as a load balancer. I've never used it as a replication tool, because the opinions I got said it's not too much stable.

If you have Hot Standby with a lot of slave servers, I'm sure PgPool is the way to go to load balancing the connections.