Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6ND6qf42824 for ; Mon, 23 Jul 2001 09:06:52 -0400 (EDT) (envelope-from pgsql-hackers-owner@postgresql.org) Received: from femail14.sdc1.sfba.home.com (femail14.sdc1.sfba.home.com [24.0.95.141]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6L56Ma73802 for ; Sat, 21 Jul 2001 01:06:22 -0400 (EDT) (envelope-from djohnson@greatbridge.org) Received: from greatbridge.org ([65.2.95.27]) by femail14.sdc1.sfba.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with ESMTP id <20010721050621.LCBM2379.femail14.sdc1.sfba.home.com@greatbridge.org>; Fri, 20 Jul 2001 22:06:21 -0700 Message-ID: <3B590CC6.5040506@greatbridge.org> Date: Sat, 21 Jul 2001 01:01:58 -0400 From: Darren Johnson User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; m18) Gecko/20010131 Netscape6/6.01 X-Accept-Language: en MIME-Version: 1.0 To: Sean Chittenden CC: pgsql-hackers@postgresql.org Subject: Re: IDEA: Multi-master replication possible through spread (or even master-slave)... References: <20010720203243.J5160@rand.tgd.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/631 X-Sequence-Number: 11451 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 >