[ivanhoe]

Originalno napisao Dragi Tata

Ali to samo znači da MySQL može da učestvuje u COM+ distribuiranim transakcijama. I dalje mi nije jasno kako LAMP može da odradi tako nešto.

Evo sta oni kazu:

The point is that all the data sources have to conform to the XA protocol. All of the data sources must be able to play the following game:

- start distributed transaction: XA START
- recieve commands from the application: SELECT, INSERT, getCustomers(), createCustomer(), ...
- close the list of commands: XA END
- make a commitment that the requested actions *can* be commited: XA PREPARE

Then the application collects the XA PREPARE response values from all data sources and decides about commit or rollback. For example, all data sources have send positive replies to XA PREPARE and the application decides to commit all subtransactions. Then it has to send out XA COMMIT to all data sources.

Neither the MySQL Server nor PHP care how many different XA compatible data sources participate in that game. And they also do not care what kind of XA compatible data sources belong to the distributed transactions: MySQL, Oracle, ... - whatever.