[Pgpool-general] Idea: peer-to-peer app architecture with pgpool?

alex koalillo at fastmail.fm
Thu Feb 5 20:33:42 UTC 2009


Jaume Sabater wrote:
>> That is, I run a couple of nodes, each with a web/app server + pgpool +
>> PostgreSQL. pgpool set to replicate write transactions to all nodes, but
>> run read queries in the local node.
>> Is this a terrible idea? Thoughts?
> More details are needed to give a proper answer but, from a first
> impression, no, it is not. It's quite common, actually.

Is it? Can I run several pgpool instances pool_a, pool_b, pool_c, each 
replicating to Postgres servers pg_a, pg_b and pg_c?

Won't they step on each other? Is there any special thing I need to 
consider?

I'll try setting up a test env and see how it goes

Alex



More information about the Pgpool-general mailing list