Re: Replication - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: Replication
Date
Msg-id 44E98337.5090308@kaltenbrunner.cc
Whole thread Raw
In response to Re: Replication  (Fujii Masao <fujii.masao@oss.ntt.co.jp>)
Responses Re: Replication
List pgsql-hackers
Fujii Masao wrote:
> Joshua D. Drake wrote:
>>> Modern systems *must* scale beyond a single computer, and the
>>> PostgreSQL support shipped in modern Linux distros is completely
>>> incapable of this.
>>
>> Slony-I is quite capable as a production class FOSS replication system
>> and is in use widely.
> 
> Slony-I is not enough because it can cause the inconsistency of data
> between servers.

hmm what are you refering to here ? slony1 does row-level replication
(something that MySQL cannot do until 5.1 which is still beta) - so it
should not be possible to cause data-inconsistency.
It is however async replication so you can loose data commited on the
master but not yet replicated to the slaves in case you loose the mastercompletely.


Stefan


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Replication
Next
From: "Magnus Hagander"
Date:
Subject: Re: BF Failure on Bandicoot