Thread: IDEA: Multi-master replication possible through spread (or even master-slave)...

        Has anyone here thought about using the spread libraries for WAL
replication amongst mutliple hosts?  With this library I think it'd be
possible to have a multi-master replication system...

http://www.spread.org/
       I'm not familiar enough with the guts of postgres to be able to
impliment this (yet), but thought that it might be something for someone
else to look into.  At the very least, check out the libs, they're very
impressive and I've had good luck with them in the past.  If push comes
to shove, in a few months I may write a few ruby+spread utils to do
this, but we'll see...  -sc

--
Sean Chittenden

    Howdy.  Darren, I'd reply in person, but there are issues with
your mail account.  ;~)  At anyrate, is there a mailing list that the
Postgres-R development is happening on so that I could drop in and
either listen/contribute? Thanks.  -sc

<djohnson@greatbridge.org>:
63.136.234.38 does not like recipient.
Remote host said: 550 <djohnson@greatbridge.org>... User unknown
Giving up on 63.136.234.38.
--- Below this line is a copy of the message.
Return-Path: <sean@mailhost.tgd.net>
Received: (qmail 9478 invoked by uid 1001); 21 Jul 2001 05:09:21 -0000
Date: Fri, 20 Jul 2001 22:09:21 -0700
From: Sean Chittenden <sean@chittenden.org>
To: Darren Johnson <djohnson@greatbridge.org>
Subject: Re: [HACKERS] IDEA: Multi-master replication possible through
spread
+(or even master-slave)...
Message-ID: <20010720220921.L5160@rand.tgd.net>
References: <20010720203243.J5160@rand.tgd.net>
+<3B590CC6.5040506@greatbridge.org>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;       protocol="application/pgp-signature";
boundary="1ppIqr1kl39GnwQx"
Content-Disposition: inline
In-Reply-To: <3B590CC6.5040506@greatbridge.org>; from
"djohnson@greatbridge.org"
+on Sat, Jul 21, 2001 at = 01:01:58AM


On Sat, Jul 21, 2001 at 01:01:58AM -0400, Darren Johnson wrote:
> Delivered-To: chittenden.org-sean-pgsql-hackers@chittenden.org
> Date: Sat, 21 Jul 2001 01:01:58 -0400
> From: Darren Johnson <djohnson@greatbridge.org>
> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; m18) Gecko/20010131 Netscape6/6.01
> X-Accept-Language: en
> To: Sean Chittenden <sean-pgsql-hackers@chittenden.org>
> CC: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] IDEA: Multi-master replication possible through spread (or even master-slave)...
>
> Sean Chittenden wrote:
>
> >         Has anyone here thought about using the spread libraries for WAL
> > replication amongst mutliple hosts?  With this library I think it'd be
> > possible to have a multi-master replication system..
>
> Yes, there is some work being done to use Spread as the group
> communication system
> for Postgres-R, but we are just getting started with this software.
> Using a group
> communication system to establish  total order messages is one of  the
> basic principles for
> synchronous multi-master replication with Postgres-R.  Currently
> Ensemble (form Cornell
> University) is used, but Spread looks to be more robust and it appears
> to be supported
> on most if not all of the PostgreSQL  supported platforms.
>
> It's very cool to see positive testimony for Spread, and I hope I will
> feel the same way
> as I become more familiar with it.

--
Sean Chittenden

Sure. The mailing list is

http://www.greatbridge.org/mailman/listinfo/pgreplication-general

It's not only for Postgres-R, but any PostgreSQL
replication ideas, discussions, or projects.
Feel free to listen or contribute.

Darren

BTW: My apologies for the email issues. Should be fixed now.

Sean Chittenden wrote:

>     Howdy.  Darren, I'd reply in person, but there are issues with
> your mail account.  ;~)  At anyrate, is there a mailing list that the
> Postgres-R development is happening on so that I could drop in and
> either listen/contribute? Thanks.  -sc

Sean Chittenden wrote:

>         Has anyone here thought about using the spread libraries for WAL
> replication amongst mutliple hosts?  With this library I think it'd be
> possible to have a multi-master replication system..

Yes, there is some work being done to use Spread as the group 
communication system
for Postgres-R, but we are just getting started with this software.  
Using a group
communication system to establish  total order messages is one of  the 
basic principles for
synchronous multi-master replication with Postgres-R.  Currently 
Ensemble (form Cornell
University) is used, but Spread looks to be more robust and it appears 
to be supported
on most if not all of the PostgreSQL  supported platforms. 

It's very cool to see positive testimony for Spread, and I hope I will 
feel the same way
as I become more familiar with it.

Darren

>