Archive for the ‘Database Programming’ Category

Two-Phase Commit Protocol

January 3, 2011 6 comments

The two phase commit protocol is a distributed algorithm which lets all sites in a distributed system agree to commit or rollback a transaction based upon consensus of all participating sites. The two phase commit strategy is designed to ensure that either all the databases are updated or none of them, so that the databases remain synchronized. The protocol achieves its goal even in many cases of temporary system.
Read more…

Categories: Database Programming

An Introduction to Bitronix JTA Transaction Manager with MySQL

December 28, 2010 1 comment

The Java Transaction API (JTA) allows applications to perform distributed transactions —to access and update systems having multiple transactional resources: databases, message queues, custom resource, or resources accessed from multiple processes, perhaps on multiple hosts, as participants in a single transaction.

The purpose of this article is to provide a high-level overview of Bitronix JTA Transaction Manager with mySQL XA datasource.
Read more…

Categories: Database Programming