Re: Replication

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Fujii Masao <fujii(dot)masao(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Replication
Date: 2006-08-21 09:56:07
Message-ID: 44E98337.5090308@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 master
completely.

Stefan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2006-08-21 11:12:11 Re: BF Failure on Bandicoot
Previous Message Fujii Masao 2006-08-21 09:07:05 Re: Replication