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

Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-docs(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
Date: 2005-04-24 16:11:13
Message-ID: m3fyxgqhni.fsf@knuth.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-docs
Martha Stewart called it a Good Thing when pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) wrote:
> Yep, big mistake my removing the replication FAQ item. I have re-added a
> new one:
>
> 	4.21) What replication solutions are available?
> 	
> 	Though "replication" is a single term, there are two major replication
> 	technologies. Multi-master replication allows read/write queries to be
> 	sent to multiple replicated computers. Using this capability has a
> 	serious performance impact. Pgcluster is the most popular such solution
> 	available for PostgreSQL. Master-slave replication allows a single
> 	master to receive read/write queries, with slaves able to accept only
> 	read/SELECT queries. The most popular master-slave PostgreSQL
> 	replication solution is Slony. There are also commercial and
> 	hardware-based replication solutions available.

A suggestion for rewording:

Though "replication" is a single term, there are a number of
approaches and technologies to handle it, and thus, for different
purposes, a number of replication systems are available.

Master/slave replication allows a single master to receive read/write
queries, where slaves can only accept read/SELECT queries.  The most
popular freely available master-slave PostgreSQL replication solution
is Slony-I.

Multi-master replication allows read/write queries to be sent to
multiple replicated computers.  Using this capability generaly has a
fairly severe impact on performance due to the need to synchronize
changes between servers.  Pgcluster is the most popular such solution
freely available for PostgreSQL.

There are also commercial and hardware-based replication solutions
available supporting a variety of replication models.
-- 
(format nil "~S(at)~S" "cbbrowne" "acm.org")
http://linuxdatabases.info/info/slony.html
"It   can be   shown   that for any  nutty  theory,  beyond-the-fringe
political view or  strange religion there  exists  a proponent  on the
Net. The proof is left as an exercise for your kill-file."
-- Bertil Jonell

In response to

Responses

pgsql-docs by date

Next:From: Jeff DavisDate: 2005-04-24 18:04:42
Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
Previous:From: Bruce MomjianDate: 2005-04-24 12:01:05
Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.

pgsql-committers by date

Next:From: Tom LaneDate: 2005-04-24 17:32:46
Subject: pgsql: Actually, nodeBitmapIndexscan.c doesn't need to create a standard
Previous:From: Tom LaneDate: 2005-04-24 15:32:07
Subject: pgsql: Put back example of using Result node to execute an INSERT.

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