Distributed Transaction In C# for Mysql

I have a C# application. I would like to run a transaction which insert and update multiple database on different location. I notice is to support via the .net connector provided by mysql. Any solution for this? What I am doing currently is that open 2 transaction then I comm开发者_如何学JAVAit one then I commit another after that which is risky as sometimes somethings fail to be updated.

Try looking into http://dev.mysql.com/doc/refman/5.0/en/xa.html.