Re: High Availability, Load Balancing, and Replication Feature Matrix - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: High Availability, Load Balancing, and Replication Feature Matrix
Date
Msg-id 200711192121.lAJLLAi07431@momjian.us
Whole thread Raw
In response to Re: High Availability, Load Balancing, and Replication Feature Matrix  (Markus Schiltknecht <markus@bluegap.ch>)
Responses Re: High Availability, Load Balancing, and Replication Feature Matrix  (Markus Schiltknecht <markus@bluegap.ch>)
List pgsql-docs
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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

pgsql-docs by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: High Availability, Load Balancing, and Replication Feature Matrix
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash