Saturday, 9 August 2014

Advantages and Disadvantages of Three Phase Commit Protocol

Advantages and Disadvantages of 3PC Protocol


Advantages of 3PC Protocol


  • The Blocking problem found in 2PC can be avoided (in certain occasions, especially when at least not more than k sites failed)

Disadvantages of 3PC Protocol


  • Network partitions (network segments) would cause Blocking Problem, especially if more than k sites are part of any partitions.  
  • Long latency due to the number of messages to be transferred between sites on taking decision. That is, it involves 3 phases and all the 3 phases involve communication between sites.
********

Three Phase Commit (3PC) Protocol - External Link



Three phase commit protocol
advantages of 3PC protocol in distributed databases
disadvantages of three phase commit (3PC) protocol in distributed database

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...