Php distributed commit

[newbie14]

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?

[sDJh]

Hi newbie14,

yes you can. You can access database via TCP virtually on every server. Have a look here: http://de.php.net/manual/en/function.mysql-connect.php

Hope that helps - Simon

[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.

[sDJh]

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().

Simon

[newbie14]

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?