From: Michael Dykman Date: October 28 2009 3:37pm Subject: Re: START TRANSACTION COMMIT ROLLBACK List-Archive: http://lists.mysql.com/mysql/219171 Message-Id: <814b9a820910280837y31b64972xc7168241eb7571ad@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable There seems to be some confusion about 'multi-db'. Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out across multiple database instances. - michael On Wed, Oct 28, 2009 at 10:08 AM, Paul DuBois wrote: > If all the tables are InnoDB, XA isn't needed. It doesn't matter whether = all > tables are in the same database. > > On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote: > >> Ah, works for InnoDB I see. >> >> Nice. >> >> >> With regards, >> >> Martijn Tonies >> Upscene Productions >> http://www.upscene.com >> >> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL >> Anywhere, MySQL, InterBase, NexusDB and Firebird! >> >> Database questions? Check the forum: >> http://www.databasedevelopmentforum.com >> >> >> =A0Looks to me we should use XA transaction syntax instead. Check this: >> >> >> =A0http://dev.mysql.com/doc/refman/5.0/en/xa.html >> >> =A0Thanks, >> =A0YY >> >> >> >> =A02009/10/28 Martijn Tonies >> >> =A0 Michael, >> >> =A0 Does MySQL support multi-db transactions? >> >> =A0 With regards, >> >> =A0 Martijn Tonies >> =A0 Upscene Productions >> =A0 http://www.upscene.com >> >> =A0 Download Database Workbench for Oracle, MS SQL Server, Sybase SQL >> =A0 Anywhere, MySQL, InterBase, NexusDB and Firebird! >> >> =A0 Database questions? Check the forum: >> =A0 http://www.databasedevelopmentforum.com >> >> >> >> >> =A0 That is correct. =A0Many db interfaces off programmatic abstractions= of >> =A0 these facilities, but you may certainly just issue the statments. >> >> =A0 START TRANSACTION >> >> =A0 INSERT that >> =A0 UPDATE that >> >> =A0 on success: COMMIT >> >> =A0 on error: ROLLBACK >> >> =A0 - michael dykman >> >> >> >> =A0 On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil >> wrote: >> >> =A0 =A0 Hello Everyone, >> =A0 =A0 I am a newbie using innodb. >> =A0 =A0 How can I implement START TRANSACTION COMMIT ROLLBACK when I nee= d to >> update >> =A0 =A0 two tables >> =A0 =A0 that are located in two different databases. Would a single STAR= T >> =A0 =A0 TRANSACTION be sufficient ? >> =A0 =A0 Any help would be appreciated. >> =A0 =A0 TIA >> =A0 =A0 Mos >> >> >> >> >> >> =A0 -- >> =A0 - michael dykman >> =A0 - mdykman@stripped >> >> =A0 "May you live every day of your life." >> =A0 =A0 Jonathan Swift > > -- > Paul DuBois > Sun Microsystems / MySQL Documentation Team > Madison, Wisconsin, USA > www.mysql.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 - michael dykman - mdykman@stripped "May you live every day of your life." Jonathan Swift