Blocking Reduction in Two-phase Commit Protocol with Multiple Backup Sites

The two-phase commit (2PC) protocol (or its variation) is widely employed for commit processing in distributed data base systems (DDBSs). The blocking phenomena in 2PC reduces the availability of the system as the blocked transactions keep all the resources until they receive the final command from the coordinator after its recovery. To remove the blocking problem in 2PC, three phase commit (3PC) protocol was proposed. Although 3PC protocol eliminates the blocking problem, it involves an extra round of message transmission, which degrades the performance in DDBS (Internet environments). To reduce blocking, we propose a backup commit (BC)protocol by attaching multiple backup sites to the coordinator site. In this protocol, after receiving responses from all participants in the first phase, the coordinator communicates the final decision to the backup sites in the backup phase. Afterwards, it sends the final decision to the participants. When blocking occurs due to the failure of the coordinator site, the participant sites can terminate the transaction by consulting a backup site of the coordinator. In this way, the BC protocol achieves non-blocking property in most of the coordinator site failures. The BC protocol suits best for World Wide Web (or Internet) environments where a server has to face high rush of electronic commerce transactions that involve multiple participants. Also in the Internet environment, sites fail frequently and messages take longer delivery time. In this situation with extra hardware, the BC protocol reduces the blocking problem without involving expensive communication cycle as compared to 3PC. Through simulation experiments it has been shown that the BC protocol exhibits superior throughput and response time performance over the 3PC protocol and performs closely with the 2PC protocol.

[1]  Michael Hammer,et al.  Reliability mechanisms for SDD-1: a system for distributed databases , 1980, TODS.

[2]  Idit Keidar,et al.  Increasing the resilience of atomic commit, at no additional cost , 1995, PODS '95.

[3]  Masaru Kitsuregawa,et al.  Reducing the blocking in two-phase commit protocol employing backup sites , 1998, Proceedings. 3rd IFCIS International Conference on Cooperative Information Systems (Cat. No.98EX122).

[4]  Miron Livny,et al.  Concurrency control performance modeling: alternatives and implications , 1987, TODS.

[5]  Dale Skeen,et al.  A Quorum-Based Commit Protocol , 1982, Berkeley Workshop.

[6]  Bharat K. Bhargava,et al.  A Study of Distributed Transaction Processing in an Internetwork , 1995, CISMOD.

[7]  Patrick Valduriez,et al.  Principles of distributed database systems (2nd ed.) , 1999 .

[8]  Jayant R. Haritsa,et al.  Revisiting commit processing in distributed database systems , 1997, SIGMOD '97.

[9]  Alok N. Choudhary Cost of distributed deadlock detection: a performance study , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[10]  Bruce G. Lindsay,et al.  Transaction management in the R* distributed database management system , 1986, TODS.

[11]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[12]  Michael Stonebraker,et al.  A Formal Model of Crash Recovery in a Distributed System , 1983, IEEE Transactions on Software Engineering.

[13]  Jim Gray,et al.  Notes on Data Base Operating Systems , 1978, Advanced Course: Operating Systems.