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: 
Ryan is a Platform Engineer at Square, where he manages thousands of instances of MySQL and PostgreSQL. Before joining Square, Ryan helped build and scale some of the largest web, social, gaming, and mobile properties as a Consultant at Percona. As an author, speaker, and active contributor to F/OSS projects, his expertise extends to a variety of data stores, cloud and big data, and beyond.
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
Senior Support Engineer, Percona
Biography: 
After 12 years working as a PHP/JS developer for local and remote firms, Marcos decided to pursuit true love and become full time DBA, so he has been doing MySQL Support at Percona for the past 5 years providing lead web properties with advise on anything-MySQL and in-depth system performance diagnostic help.
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