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

Re: High Availability, Load Balancing, and Replication Feature Matrix

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix
Date: 2007-11-23 13:21:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-hackers
Hello Bruce,

Bruce Momjian wrote:
> Uh, to me the issue is something like pgpool and Sequoia, where the
> _master_/replication is happening _outside_ the server

Well, you are saying that the controllers are the masters and do 
replication. I can see the reasoning behind it: they are the only nodes 
  which allow write access, seen from the outside.

However, I don't consider these controllers to be masters nor slaves, 
because they don't carry a replica of the data. Instead I'm considering 
the database nodes which are (synchronously or not) processing the 
writing transactions on behalf of the controller to be the masters. They 
do all the work and the locking, and they carry the replicated data.

PgCluster (and therefore Cybercluster, too) seem to follow my 
definition, as they are advertising themselves as multi-master 
replication solutions (even though they only support one single 
controller, AFAICT).

I didn't find any self-definition of PgPool's replication feature nor 
Sequoias. However, I'd argue that both are generally considered 
synchronous multi-master replication solutions as well, even if there's 
only one controller.

 > vs something
 > like Oracle RAC where it is happening inside the server.

..or like Postgres-R :-)



In response to

pgsql-docs by date

Next:From: ErikjanDate: 2007-11-26 21:15:29
Subject: create_index inconsistency (patch)
Previous:From: Bruce MomjianDate: 2007-11-22 16:23:14
Subject: Re: About contrib modules

pgsql-hackers by date

Next:From: Zeugswetter Andreas ADI SDDate: 2007-11-23 13:40:40
Subject: Re: Ordered Append Node
Previous:From: Heikki LinnakangasDate: 2007-11-23 13:11:44
Subject: Re: Ordered Append Node

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