X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 572E3D1B8DD for ; Mon, 25 Aug 2003 15:25:22 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 99853-02 for ; Mon, 25 Aug 2003 15:24:51 -0300 (ADT) Received: from cm-lcon2-53-101.cm.vtr.net (CM-lcon2-53-101.cm.vtr.net [200.83.53.101]) by svr1.postgresql.org (Postfix) with ESMTP id A3C6FD1B8D1 for ; Mon, 25 Aug 2003 15:24:49 -0300 (ADT) Received: by cm-lcon2-53-101.cm.vtr.net (Postfix, from userid 500) id 7E59680223; Mon, 25 Aug 2003 14:24:41 -0400 (CLT) Date: Mon, 25 Aug 2003 14:24:41 -0400 From: Alvaro Herrera To: Chris Travers Cc: Ron Johnson , pgsql-general@postgresql.org Subject: Re: Replication Ideas Message-ID: <20030825182441.GB9597@dcc.uchile.cl> References: <3F483EBD.3020108@travelamericas.com> <1061705587.3733.452.camel@haggis> <3F4A420E.6090604@travelamericas.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F4A420E.6090604@travelamericas.com> User-Agent: Mutt/1.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1306 X-Sequence-Number: 47722 On Mon, Aug 25, 2003 at 10:06:22AM -0700, Chris Travers wrote: > Ron Johnson wrote: > > >This is vaguely similar to Two Phase Commit, which is a sine qua > >non of distributed transactions, which is the s.q.n. of multi-master > >replication. > > I may be wrong, but if I recall correctly, one of the problems with a > standard 2-phase commit is that if one server goes down, the other > masters cannot commit their transactions. Before the discussion goes any further, have you read the work related to Postgres-r? It's a substantially different animal from 2PC AFAIK. -- Alvaro Herrera () "Right now the sectors on the hard disk run clockwise, but I heard a rumor that you can squeeze 0.2% more throughput by running them counterclockwise. It's worth the effort. Recommended." (Gerry Pourwelle)