Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

2 Phase Commit[My SQL]

 
Asgar Ali
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Asgar Ali
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, the default (as I remember) is the MyISAM. The documentation will help you.
 
Campbell Ritchie
Sheriff
Pie
Posts: 50196
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic