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?
Look into some form of mysql replication. Either master/slave or master/master replication would allow you to point your php app to a single ip and let the replication handle the rest.
Dear Speda,
The problem here is that. I have one local db and one central db and a copy of the local db which is located same as the central db. For the local transaction most of it I will do an update and insert. So the same apply for the local copy. The problem is that for the central it will be mostly updates. So for some of the insert I dont want it to be replicated into the central db is that possible?