Re: Replication Using Triggers

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