Distributed Transactions: A Primer with MySQL

Replication and High Availability Strategies
25 April 3:00pm - 3:50pm @ Ballroom C

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.

Speakers

Ryan Lowe
Production Engineer, Square, Inc.
Biography: 
N/A
Fernando Ipar
Senior Consultant, Percona
Biography: 
Fernando works as Senior Consultant at Percona. Prior to joining the company, he worked as a contractor for several financial services institutions, telcos, and smaller technology providers. During that period, he acquired experience managing different UNIX type systems, developing or improving fault tolerant software, and managing small teams of technically skilled people. He has been involved in the Open Source Community as a user since 1997, and as a contributor since 2001, when he deployed his first production MySQL server and right away started working on a set of scripts to manage master/slave pairs via the mysql-ha (later renamed highbase) project. Since then, he has continued to be actively involved in the community, more recently with contributions to Percona Toolkit and MySQL Fabric. He lives with his family in Montevideo, Uruguay. When not working, he enjoys family life, music and coffee.
Marcos Albe
Support Engineer, Percona
Biography: 
Marcos Albe has been doing web development for over ten years, providing solutions for various media and technology companies of different sizes. He is now a member of the Percona Support Team. Born and raised in the city of Montevideo, Uruguay, he became passionate about computers at the age of 11, when he got a 25Mhz i386-SX. Some ten years later, he became one of the pioneers in telecommuting in Uruguay while leading the IT efforts for the second largest newspaper in the country. Marcos also has a passion for teaching. As the first Zend Certified Engineer in Uruguay, he provided PHP training for several companies, and he also gave free workshops to public college students. His motto is: Teaching is the best way to learn. At the age of 32, he became a father and husband, which has made him truly happy. He is planning to move to a more quiet town to raise his toddler.
Randy Wigginton
Engineer, Square, Inc.
Biography: 
Randy's obsession with computers began in 1974 when he was just 14 years old. In 1977, Randy joined a new company called Apple Computer as their first software engineer and employee #6. While at Apple, Randy wrote MacWrite, the world's first WYSIWYG word processor, for the launch of the Macintosh in 1984. Randy's career spans many of Silicon Valley's most notable companies such as E*TRADE, eBay and Google. In 2011, Randy joined Square and has most notably built the payment gateways to the company's payment partners today.

Slides