Re: Replication Using Triggers - Mailing list pgsql-general

From Gordan Bobic
Subject Re: Replication Using Triggers
Date
Msg-id 47929703.3050805@bobich.net
Whole thread Raw
In response to Re: Replication Using Triggers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Replication Using Triggers
List pgsql-general
Scott Marlowe wrote:
> On Jan 19, 2008 6:14 PM, Gordan Bobic <gordan@bobich.net> wrote:
>> Gregory Youngblood wrote:
>>> On Sat, 2008-01-19 at 23:46 +0000, Gordan Bobic wrote:
>>>> David Fetter wrote:
>>>>> In that case, use one of the existing solutions.  They're all way
>>>>> easier than re-inventing the wheel.
>>>> Existing solutions can't handle multiple masters. MySQL can do it at
>>>> least in a ring arrangement.
>>>>
>>> What about pgcluster? It's supposed to be able to provide synchronous
>>> multi-master replication for postgresql.
>> I looked at that, too, but it wasn't really a "cluster of equal peers"
>> sort of solution, which is what I am after. Still, thanks for pointing
>> it out.
>
> Oh, and there's this too:
>
> Cybertec sync-multi-master
> http://www.postgresql.org/about/news.752
> http://www.postgresql.org/about/news.752

The design of that seems suspiciously similar to pgcluster with separate
load balancer and replicator servers.

Gordan

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Replication Using Triggers
Next
From: Andreas 'ads' Scherbaum
Date:
Subject: Re: Replication Using Triggers