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 C1584D1B8C6 for ; Mon, 25 Aug 2003 14:38:47 -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 84902-09 for ; Mon, 25 Aug 2003 14:38:16 -0300 (ADT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9AED1B8D4 for ; Mon, 25 Aug 2003 14:38:15 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao01.cox.net (InterMail vM.5.01.06.04 201-253-122-130-104-20030726) with ESMTP id <20030825173816.PNLO5378.lakemtao01.cox.net@lhosts> for ; Mon, 25 Aug 2003 13:38:16 -0400 Subject: Re: Replication Ideas From: Ron Johnson To: PgSQL General ML In-Reply-To: <3F4A420E.6090604@travelamericas.com> References: <3F483EBD.3020108@travelamericas.com> <1061705587.3733.452.camel@haggis> <3F4A420E.6090604@travelamericas.com> Content-Type: text/plain Message-Id: <1061833095.11311.61.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Mon, 25 Aug 2003 12:38:16 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1304 X-Sequence-Number: 47720 On Mon, 2003-08-25 at 12:06, 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. This would make a clustered > database server have a downtime equivalent to the total downtime of all > of its nodes. This is a real problem. Of course my understanding of > Two Phase Commit may be incorrect, in which case, I would appreciate it > if someone could point out where I am wrong. Note that I didn't mean to imply that 2PC is sufficient to implement M-M. The DBMS designer(s) must decide what to do (like queue up changes) if 2PC fails. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "Our computers and their computers are the same color. The conversion should be no problem!" Unknown