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

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Markus Schiltknecht <markus(at)bluegap(dot)ch>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix
Date: 2007-11-19 21:21:10
Message-ID: 200711192121.lAJLLAi07431@momjian.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
Markus Schiltknecht wrote:
> Eh.. I think you misunderstood. The Sequoia people use RAIDb to mean 
> Redundant Array of Inexpensive _Databases_. A possible setup might look 
> like:

You are right.  I didn't understand that.  Interesting.

> > I am afraid we are stuck between clarity and understand-ability here. ;-)
> 
> Agreed, but that's where I think the current chapter creates confusion 
> by trying to separate into "statement based replication middleware" and 
> "synchronous multi-master replication". Such a separation does not 
> exist, instead every combination of single vs. multi-master and 
> statement based vs tuple based is possible. Examples:
> 
> single-master, tuple based: Slony-I, Mammoth Replicator
> multi-master, tuple based: Postgres-R, Slony-II, maybe Bucardo (?)
> single-master, statement based: maybe pgpool or skytools can do that (?)
> multi-master, statement based: Sequoia, PgCluster

Uh, to me the issue is something like pgpool and Sequoia, where the
_master_/replication is happening _outside_ the server, vs something
like Oracle RAC where it is happening inside the server.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-docs by date

Next:From: Thomas HaegiDate: 2007-11-21 02:25:14
Subject: BUG #3767: tsearch2 index creation fatal crash
Previous:From: Markus SchiltknechtDate: 2007-11-19 19:51:27
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix

pgsql-hackers by date

Next:From: Guillaume LelargeDate: 2007-11-19 21:34:00
Subject: Re: Terminal width for help output
Previous:From: Markus SchiltknechtDate: 2007-11-19 19:51:27
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix

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