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

Re: Core team statement on replication in PostgreSQL

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Robert Hodges" <robert(dot)hodges(at)continuent(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David Fetter" <david(at)fetter(dot)org>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Core team statement on replication in PostgreSQL
Date: 2008-05-29 19:16:57
Message-ID: b42b73150805291216n6ea5c151u59a3e33671a4640e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
On Thu, May 29, 2008 at 3:05 PM, Robert Hodges
<robert(dot)hodges(at)continuent(dot)com> wrote:
> Third, you can't stop with just this feature.  (This is the BUT part of the
> post.)  The use cases not covered by this feature area actually pretty
> large.  Here are a few that concern me:
>
> 1.) Partial replication.
> 2.) WAN replication.
> 3.) Bi-directional replication.  (Yes, this is evil but there are problems
> where it is indispensable.)
> 4.) Upgrade support.  Aside from database upgrade (how would this ever
> really work between versions?), it would not support zero-downtime app
> upgrades, which depend on bi-directional replication tricks.
> 5.) Heterogeneous replication.
> 6.) Finally, performance scaling using scale-out over large numbers of
> replicas.  I think it's possible to get tunnel vision on this—it's not a big
> requirement in the PG community because people don't use PG in the first
> place when they want to do this.  They use MySQL, which has very good
> replication for performance scaling, though it's rather weak for
> availability.

These type of things are what Slony is for.  Slony is trigger based.
This makes it more complex than log shipping style replication, but
provides lots of functionality.

wal shipping based replication is maybe the fastest possible
solution...you are already paying the overhead so it comes virtually
for free from the point of view of the master.

mysql replication is imo nearly worthless from backup standpoint.

merlin

In response to

Responses

pgsql-hackers by date

Next:From: Brian HurtDate: 2008-05-29 19:21:24
Subject: Re: Core team statement on replication in PostgreSQL
Previous:From: Merlin MoncureDate: 2008-05-29 19:10:50
Subject: Re: [PERFORM] Memory question on win32 systems

pgsql-advocacy by date

Next:From: Brian HurtDate: 2008-05-29 19:21:24
Subject: Re: Core team statement on replication in PostgreSQL
Previous:From: Robert HodgesDate: 2008-05-29 19:05:18
Subject: Re: Core team statement on replication in PostgreSQL

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