public inbox for [email protected]  

help / color / mirror / Atom feed

From: Christopher Browne <[email protected]>
To: [email protected]
Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
Date: Sun, 24 Apr 2005 12:11:13 -0400
Message-ID: <[email protected]> (raw)
References: <[email protected]>
	<[email protected]>

Martha Stewart called it a Good Thing when [email protected] (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@~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

view thread (15+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox