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?
newbie14 0 Posting Pro
sDJh 39 Posting Whiz in Training
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 0 Posting Pro
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 39 Posting Whiz in Training
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 0 Posting Pro
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?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.