From: Eugene Ogurtsov <eogurtsov@swsoft.com>
To: Craig A. James <cjames@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Replication
Date: Fri, 15 Jun 2007 09:17:46 +0700
Message-ID: <4671F6CA.2090908@swsoft.com> (raw)
In-Reply-To: <4671CB7A.6000909@emolecules.com>
References: <4671CB7A.6000909@emolecules.com>
What about "Daffodil Replicator" - GPL -
http://sourceforge.net/projects/daffodilreplica/
--
Thanks,
Eugene Ogurtsov
Internal Development Chief Architect
SWsoft, Inc.
Craig A. James wrote:
> Looking for replication solutions, I find:
>
> Slony-I
> Seems good, single master only, master is a single point of failure,
> no good failover system for electing a new master or having a failed
> master rejoin the cluster. Slave databases are mostly for safety or
> for parallelizing queries for performance. Suffers from O(N^2)
> communications (N = cluster size).
>
> Slony-II
> Seems brilliant, a solid theoretical foundation, at the forefront of
> computer science. But can't find project status -- when will it be
> available? Is it a pipe dream, or a nearly-ready reality?
>
> PGReplication
> Appears to be a page that someone forgot to erase from the old GBorg
> site.
>
> PGCluster
> Seems pretty good, but web site is not current, there are releases in
> use
> that are not on the web site, and also seems to always be a couple steps
> behind the current release of Postgres. Two single-points failure
> spots,
> load balancer and the data replicator.
>
> Is this a good summary of the status of replication? Have I missed
> any important solutions or mischaracterized anything?
>
> Thanks!
> Craig
>
> (Sorry about the premature send of this message earlier, please ignore.)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
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-performance@postgresql.org
Cc: eogurtsov@swsoft.com, cjames@emolecules.com
Subject: Re: Replication
In-Reply-To: <4671F6CA.2090908@swsoft.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