Skip site navigation (1) Skip section navigation (2)

Re: Replication

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Replication
Date: 2007-06-14 23:22:25
Message-ID: 4671CDB1.3090708@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Craig 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).

Yep

> 
> 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?
> 

Dead


> PGReplication
> Appears to be a page that someone forgot to erase from the old GBorg site.
> 

Dead


> 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.
> 

Slow as all get out for writes but cool idea

> Is this a good summary of the status of replication?  Have I missed any 
> important solutions or mischaracterized anything?
> 

log shipping, closed source solutions


> Thanks!
> Craig
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 


In response to

Responses

pgsql-performance by date

Next:From: BenDate: 2007-06-14 23:26:10
Subject: Re: Replication
Previous:From: Craig JamesDate: 2007-06-14 23:14:02
Subject: Replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group