From: Jaume Sabater <jsabater@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: suggestions/hints for multimaster solution
Date: Fri, 9 Jan 2009 12:13:15 +0100
Message-ID: <3786f7bb0901090313l2780aba8ia87d0a41e82acdec@mail.gmail.com> (raw)
In-Reply-To: <496727D0.9070801@transporeon.com>
References: <496727D0.9070801@transporeon.com>
On Fri, Jan 9, 2009 at 11:32 AM, Gerd König <koenig@transporeon.com> wrote:
> Perhaps we should have a look at
> * pg_pool(II)
I can only speak of pgpool-II. It's working fine for me in a setup
which is exactly the same one you have (change OpenSuse for Debian,
but the rest is the same). The thing is that pgpool-II itself can
become a single point of failure unless you provide HA for it (I am
doing so with Heartbeat), but IMHO that would then be a failover
solution, not a multimaster (from pgpool-II's point of view, not the
databases behind pgpool-II).
Next thing I want to do is try Slony-I with pgpool-II, but I think
that is not a multimaster solution either.
Of course we may have different points of view on what multimaster mean :)
If you plan on using pgpool-II, take into consideration that
replication is done at a SQL query level, which is cool, but has its
limitations. If you use Slony-I inside pgpool-II I think you can take
over those limitations, but the solution is not so... neat, so to
speak :)
/discuss
--
Jaume Sabater
http://linuxsilo.net/
"Ubi sapientas ibi libertas"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jsabater@gmail.com
Subject: Re: suggestions/hints for multimaster solution
In-Reply-To: <3786f7bb0901090313l2780aba8ia87d0a41e82acdec@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox