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
>
>
> Looks to me we should use XA transaction syntax instead. Check this:
>
>
> http://dev.mysql.com/doc/refman/5.0/en/xa.html
>
> Thanks,
> YY
>
>
>
> 2009/10/28 Martijn Tonies <m.tonies@stripped>
>
> Michael,
>
> Does MySQL support multi-db transactions?
>
> 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
>
>
>
>
> That is correct. Many db interfaces off programmatic
> abstractions of
> these facilities, but you may certainly just issue the statments.
>
> START TRANSACTION
>
> INSERT that
> UPDATE that
>
> on success: COMMIT
>
> on error: ROLLBACK
>
> - michael dykman
>
>
>
> On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil <moszamil@stripped
> > wrote:
>
> Hello Everyone,
> I am a newbie using innodb.
> How can I implement START TRANSACTION COMMIT ROLLBACK when I
> need to update
> two tables
> that are located in two different databases. Would a single START
> TRANSACTION be sufficient ?
> Any help would be appreciated.
> TIA
> Mos
>
>
>
>
>
> --
> - michael dykman
> - mdykman@stripped
>
> "May you live every day of your life."
> Jonathan Swift
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
