Gavin Towey is a senior Database Administrator at Box working on database operations, performance, and writing tools to make managing databases easier. He has worked with MySQL since 3.23 as a developer and has been a dedicated DBA for the past 7 years. He has managed large mysql installations with hundreds of instances, many terabytes of data, and billions of queries per day.
So you've got MySQL running in your business. You've gotten a handle on replication, performance and backing up your database. You're an experienced MySQL DBA and can troubleshoot, repair and design schemas. What's next? How do you take the next step and turn your database into a polished, professional service? This talk with follow the journey made by the DBA team at... [read more]
We present two open source tools developed at Box that are simple to use and very powerful: Anemometer is a query performance tracking tool which leverages Percona's pt-query-digest tool to help gather detailed query execution data, and them provides a drop-dead simple interface for analyzing and reporting on that data. It allows you to monitor performance across many individual database... [read more]