Re: protocol change in 7.4
От | Maarten Boekhold |
---|---|
Тема | Re: protocol change in 7.4 |
Дата | |
Msg-id | T5e5f6719bcc407b70784c@reuters.com обсуждение исходный текст |
Ответ на | protocol change in 7.4 (Neil Conway <neilc@samurai.com>) |
Список | pgsql-hackers |
<br /><font face="sans-serif" size="2">On 11/05/2002 04:42:55 AM Neil Conway wrote:<br /> > Mike Mascari <mascarm@mascari.com>writes:<br /> > > Is there any thought about changing the protocol to support<br /> >> two-phase commit? Not that 2PC and distributed transactions would be<br /> > > implemented in 7.4, but toprevent another protocol change in the<br /> > > future?<br /> > <br /> > My understanding is that 2PC is oneway to implement multi-master<br /> > replication. If that's what you're referring to, then I'm not sure I<br /></font><br/><font face="sans-serif" size="2">Another use of two-phase commit is in messaging middleware (MOM, message orientedmiddleware), were both the middleware and the database participate in the same transaction. Consider:</font><br /><br/><font face="sans-serif" size="2">- DB: begin</font><br /><font face="sans-serif" size="2">- MOM: begin</font><br /><fontface="sans-serif" size="2">- DB: insert</font><br /><font face="sans-serif" size="2">- MOM: send message</font><br/><font face="sans-serif" size="2">- DB: prepare</font><br /><font face="sans-serif" size="2">- MOM: prepare==> fails</font><br /><font face="sans-serif" size="2">- DB: rollback</font><br /><font face="sans-serif" size="2">-MOM: rollback</font><br /><br /><font face="sans-serif" size="2">just a simple example...</font><br /><br /><fontface="sans-serif" size="2">Maarten</font> <code><font size="3"><br /><br /> ----------------------------------------------------------------<br /> Visit our Internet site at http://www.reuters.com<br/><br /> Get closer to the financial markets with Reuters Messaging - for more<br /> informationand to register, visit http://www.reuters.com/messaging<br /><br /> Any views expressed in this message are thoseof the individual<br /> sender, except where the sender specifically states them to be<br /> the views of Reuters Ltd.<br/></font></code>
В списке pgsql-hackers по дате отправления: