InnoDB: A journey to the core II

Database Administration
2 April 2:20PM - 3:10PM @ Ballroom D

Experience level: 
50 minutes conference
In this new installment of the series, we explore the most crucial structures for crash recovery and consistency, the redo and undo logs. This presentation dissects the structure and organization of InnoDB's redo and undo logs, providing insight into how data changes occur at the InnoDB layer and how it guarantees that it can recover to a consistent state in the event of a crash. This presentation will increase your understanding of how data travels through InnoDB.


Senior Software Engineer, LinkedIn
Davi Arnaut is a member of the MySQL development team at LinkedIn. He works closely with LinkedIn's data team to add new features to MySQL, evaluate performance, and track down and fix bugs. In the past, Davi was a lead software engineer in the MySQL development teams at Twitter and Oracle.
Sr. Systems Engineer, Google, Inc.
Jeremy Cole is a long-time MySQL Geek and pioneer of MySQL scalability. Jeremy started his MySQL adventure in 2000 as the fourteenth employee of a startup: MySQL AB. His initial work was primarily on documentation and core development, soon transitioning into support, and finally running the training and consulting organization during his four and a half years there. After MySQL, Jeremy coined the “MySQL Geek” title at Yahoo!, supporting hundreds of internal users of MySQL and many thousands of MySQL servers within Yahoo!’s infrastructure, as well as building a large team of MySQL experts around the world. Jeremy went on to found one of the premier MySQL consulting companies, Proven Scaling, which during its more than three years of operation provided detailed advice, optimization, new tools, and hands-on DBA and emergency support to more than 100 influential companies. For more than two years, Jeremy managed the growing team of DBAs at Twitter, keeping the world tweeting. Jeremy is currently making MySQL more awesome at Google.