MySQL Forums
Forum List  »  InnoDB

Two Phase Commit
Posted by: Martin Schumacher
Date: March 03, 2005 07:22AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Two Phase Commit
5686
March 03, 2005 07:22AM
3327
March 03, 2005 08:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.