From: Stephen Tu Date: November 17 2012 4:23pm Subject: Re: XA Transactions and number of Round Trips List-Archive: http://lists.mysql.com/mysql/228648 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d043c82222e679b04ceb34f45 --f46d043c82222e679b04ceb34f45 Content-Type: text/plain; charset=ISO-8859-1 On Sat, Nov 17, 2012 at 5:21 AM, Cary Cherng wrote: > Does this mean that two-phase commit incurs 3 round trips? One round trip > for the branches of the global transaction to be sent, executed at their > local site, and a response. A second round trip for the prepare phase > message and response. A third round trip for the commit phase message and > response. > From my understanding of XA, I think it's even worse than three round trips, because you also have to issue XA BEGIN/XA END to delimit the 2PC transaction. So I think there are five round trips involved in total. --f46d043c82222e679b04ceb34f45--