The system model of having a standardized api for independent transactions was created by X/Open. This allows databases and different transaction managers to interoperate. XA and 2PC do have a fair amount of overhead but for me this defines "Enterprise Ready".
Who supports XA Transactions?
MySQL - No
SAPDB/MAXDB - No
Postgresql - No - in the works (8.1/8.2?)
Firebird - Yes
Berkeley DB - Yes
Ingres - Yes
An extensive discussion of the use of XA Transactions can be found on the Server Side Review
Posted by Anthony at February 22, 2005 12:11 PM | TrackBack