2 Phase Commit[My SQL]

Hi,
I have a question. I am trying to learn how 2 phase commit works between 2 different resources, database and message queue. I am using MySql 5.1 trial version for that. DO I need to make some changes to mysql database inorder to make it work for a 2 phase commit.
Any documentation will help
Thanks
Asgar

You'll have to your the right database engine. I think its only the InnoDB one that supports XA transactions. Other than that it should work.

Thanks, So if I create a database, will It pick up the InnoDB engine by default or I need to do some sort of configuration?

No, the default (as I remember) is the MyISAM. The documentation will help you.

I think you are right, Paul. You write

ENGINE=InnoDB;

at the end of a table declaration, or you can probably add a similar declaration to a database creation statement.
[ October 22, 2008: Message edited by: Campbell Ritchie ]