Re: 2-phase commit - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 2-phase commit
Date
Msg-id 29978.1063173788@sss.pgh.pa.us
Whole thread Raw
In response to Re: 2-phase commit  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: 2-phase commit  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> From our previous discussion of 2-phase commit, there was concern that
> the failure modes of 2-phase commit were not solvable.  However, I think
> multi-master replication is going to have similar non-solvable failure
> modes, yet people still want multi-master replication.

No.  The real problem with 2PC in my mind is that its failure modes
occur *after* you have promised commit to one or more parties.  In
multi-master, if you fail you know it before you have told the client
his data is committed.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats Collector Error 7.4beta1 and 7.4beta2
Next
From: Darko Prenosil
Date:
Subject: Trouble with error message encoding