Two-phase commit protocol
The two-phase commit protocol provides an automatic recovery mechanism in case a system or media failure occurs during execution of the transaction. The two-phase commit protocol ensures that all participating database servers receive and implement the same action (either to commit or to roll back a transaction), regardless of local or network failure.
If any database server is unable to commit its portion of the transaction, all database servers participating in the transaction must be prevented from committing their work.