Re: 2-phase commit

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