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

Re: [Pgcluster-general] PostgreSQL Documentation of High Availability

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: a(dot)mitani(at)sra-europe(dot)com
Cc: pgsql-docs(at)postgresql(dot)org, pgcluster-general(at)pgfoundry(dot)org, bruce(at)momjian(dot)us
Subject: Re: [Pgcluster-general] PostgreSQL Documentation of High Availability
Date: 2006-11-20 16:17:56
Message-ID: 4561D534.1050502@bluegap.ch (view raw or flat)
Thread:
Lists: pgsql-docs
Hi,

a(dot)mitani(at)sra-europe(dot)com wrote:
> Current generation of PGCluster is a Shared-Nothing type of multi-master
> and syncronous replication system.

Thank you for pointing us to yet another very common distinction in the
clustering world: shared-nothing vs. shared-disk or even
shared-everything. We don't touch that in the current documentation. Do
we want or need to do so?

> I think that the feature of this type of replication system is as the
> 'Multi-Master Replication Using Clustering' chapter of your document.

Most probably, yes. Please note that it's not *my* document :-)  Bruce
Momjian wrote most of it, with only some hints and annoying nit-picking
from my side.

> However, Oracle RAC is a Shared-Everything type of multi-master clustering
> system. If it set up appropriately, most of these limitations would be
> improved.

Shared-Everything, really? I thought they did their own distributed
shared memory or distributed locking stuff, so it would be shared-disk.
And together with their OCFS, they would reach shared-nothing. But I
don't really know.

@pgsql-docs: I'd strongly vote for not mentioning Oracle if we don't
event want to mention proprietary products for PostgreSQL. There are
enough research or ongoing projects (even some ongoing reserch projects
;-)  ) to mention. PgCluster-II, GORDA, Slony-II or Postgres-R come to mind.

> Next generation of PGCluster (I named PGCluster-II) will be a
> Shared-Everything type of multi-master clustering system as demonstrated
> in Toronto.

Yeah, I remember that demonstration. Do you think PGCluster-II fits
what's described under 'Multi-Master Replication Using Clustering'? Do
you think we should explain Shared-Nothing vs. Shared-Disk vs.
Shared-Everything there?

Regards

Markus

In response to

Responses

pgsql-docs by date

Next:From: Markus SchiltknechtDate: 2006-11-20 19:06:37
Subject: Re: [Pgcluster-general] PostgreSQL Documentation of High Availability
Previous:From: Markus SchiltknechtDate: 2006-11-20 15:35:25
Subject: Re: [HACKERS] Replication documentation addition

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