Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

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

26 April - 2:00 PM - 2:50 PM at Ballroom A
Overview: Many MySQL shops have made the transition from MySQL 5.5 to 5.6 in the last few 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 50 minute presentation covers GTID concepts, the process for converting from default... [read more]
25 April - 2:20 PM - 3:10 PM at Ballroom E
Overview: There are a number of built-in MySQL commands and third party tools out there for generating data to help tune and diagnose your servers. All that information is great, but not always easy to parse through; especially if you are in the middle of an emergency. What do you do when you need to see only the non-sleeping processlist threads, pick out the top 5 longest currently running... [read more]