On 11/05/2002 04:42:55 AM Neil Conway wrote:
> Mike Mascari <mascarm@mascari.com> writes:
> > Is there any thought about changing the protocol to support
> > two-phase commit? Not that 2PC and distributed transactions would be
> > implemented in 7.4, but to prevent another protocol change in the
> > future?
> 
> My understanding is that 2PC is one way to implement multi-master
> replication. If that's what you're referring to, then I'm not sure I

Another use of two-phase commit is in messaging middleware (MOM, message oriented middleware), were both the middleware and the database participate in the same transaction. Consider:

- DB: begin
- MOM: begin
- DB: insert
- MOM: send message
- DB: prepare
- MOM: prepare ==> fails
- DB: rollback
- MOM: rollback

just a simple example...

Maarten


------------------------------------------------------------- ---
        Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging

Any views expressed in this message are those of  the  individual
sender,  except  where  the sender specifically states them to be
the views of Reuters Ltd.


Tue, 05 Nov 2002 10:58:34 +0400
Maarten Boekhold <Maarten.Boekhold@reuters.com>
Re: protocol change in 7.4