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.