摘要 |
Techniques are provided for handling distributed transaction in shared-nothi ng database system where one or more of the nodes have access to a shared persistent storage. Rather than coordinate the distributed transaction using a two-phase commit protocol, the coordinator of the distributed transaction us es a one-phase commit protocol with those participants that have access to the transaction status information maintained by the coordinator. The transactio n status information may reside, for example, in the redo log of the coordinator. In case that the coordinator fails, those participants can determine the state of the distributed transaction based on information stor ed on the shared disk. In addition, the coordinator is able to determine whethe r it is possible to commit the distributed transaction based on information th at is stored on the shared disk by the participants, without those participants entering a formal "prepared " state.
|