Forum OpenACS Development: Load balancing in Postgres

Collapse
1: Load balancing in Postgres
Posted by Jose Agustin Lopez Bueno on 02/07/06 09:51 AM
Hello!

I am searching a tool for load balancing (or
caching selects) of our PG DB. I have found to
possibilities:

-pgpool: It is a good tool but we have to inspect all
the selects. I read on docs:

SELECT query is not in a transatcion block.
Please note that a SELECT may modify databases by
calling a updatable function. In this case you
should NOT use the load balancing. Othewise pgpool
will fail due to the contents difference between the
master and the secondary database. You can avoid the
load balancing by putting spaces or comments in the
begining of the query.

-memcache: Anybody has one tcl API for this library?
-Other tool???

Any experience?

Regards,
Agustin

Collapse
2: Re: Load balancing in Postgres (response to 1)
Posted by Gustaf Neumann on 02/07/06 11:04 AM
see here:
http://www.citeulike.org/opensource/memcached.adp

we did some experiments with it, but decided on the short term not to go this way.

-gustaf

Collapse
3: Re: Load balancing in Postgres (response to 1)
Posted by Andrew Piskorski on 02/08/06 02:14 PM
There is also pgmemcache for PostgreSQL, and Harish Krishnan's small Tcl interface to memcached. More info on both of those from Oct. 2005 in the NetV, memcached thread.