Distributed Transactions: A Primer with MySQL
Distributed transaction support is one of the most interesting, yet underutilized, aspects of MySQL. This session will begin with a discussion of the nature of distributed transactions as well as their failure points and cover some common roll-your-own solutions. We'll finish by implementing a distributed money-transfer system using MySQL XA. Attendees of this talk will be able to identify areas within their application where distributed transactions make sense as well as being able to implement a proper distributed transaction processing system using MySQL.