Dear All,
I would like to know can php support distributed transaction for mysql database? The problem I have a scenario to update two db which are located in different location?

6 Years
Discussion Span
Last Post by newbie14

Dear Simon,
I visited the link you gave me but is just showing the normal mysql_connect function so where is the one for the distributed commit? Thank you.


Hi newbie,

I can't tell you if there is a library for distributed transactions in PHP/MYSQL. I think you have to write something like that yourself.
I don't know what you want to achieve with your code but it's basically nothing more than double-checking the synchronized databases on two servers. And that can be done with mysql_connect().



Dear Simon,
What I want is like this first I have local of a db.Then one submit of the form just say I will need to insert and update in another of this local db in the cental server. At the same time in the central server I also have a central db which I will do mostly update statement only. So I hope I am clearer now?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.