Two Phase Commit

[Martin Schumacher]

Hello,

Could someone please help me answering a few of those questions?


- does MySQL support Two Phase Commit?

- If it does support Two Phase Commit,
does it support it according to the XA-Protocol?

- Is it possible, to do a Recovery of the
databases involved in the distributed transaction
up to a certain distributed transaction?

- Database Links inside SQL:
Can i write something like "select * from table@mydblink"
where @mydblink points to another MySQL database somewhere in the world?

- Database Gateways inside the Database:
Can i write something like "select * from gatewaytable"
where gatewaytable in fact is a table in another MySQL database somewhere in the world?

- Is it possible to set a timeout value after that long running
SQL statements are being cancelled by the database?


thx in advance!
Greetings,
Martin