Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Brian Cain


Brian Cain's picture

Brian Cain

Database Engineer - MySQL SRE, Dropbox


Biography:

Brian is a Database Engineer MySQL SRE for Dropbox. He has worked with MySQL for the past 5 years supporting multiple client environments as a consultant or FTE. He spends most of his time as an operational DBA automating routine tasks such as instance cloning and master promotions along with enhancing monitoring and alerts to proactively detect upcoming issues. He has a background as a developer, manager, and systems administrator over the past 20+ years. Brian is based out of Seattle, WA.


Sessions

19 April 04:50 PM - 5:15 PM at Room 210
Overview: Imagine that your MySQL server is alerting on too many open transactions and the history list is out of control. SHOW PROCESSLIST displays a long line of connections in a sleep state with NULL info. SHOW ENGINE INNODB STATUS shows active transactions, but again there is nothing to determine what is running behind that “Sleep”. What happened within the connection? Was it just an INSERT,... [read more]
18 April 9:30AM - 12:30PM at Ballroom C
Overview: Many MySQL shops have made the transition from MySQL 5.5 to 5.6 in the last two years, but GTID (global transaction identifier) implementation has often been considered too difficult or risky a change. MySQL 5.7 is making GTID implementation easier, but it may not yet be clear why to convert. This 3 hour tutorial will cover GTID concepts, provide hands-on experience for converting from... [read more]