[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