Andrew Moore

Remote DBA, Percona

A production MySQL DBA with years of eclectic experience in MySQL versions, replacements, platforms and problems. Beginning life as a Production DBA working within Nokia's Music service with SQL Server, the company's direction gave Andrew the opportunity to work at scale with MySQL 5.1 and gain DBA certification. In 2011 Andrew took a remote position with the Pythian Group and sharpened his skill set to include new products and techniques non-existing among the Nokian environments. Since fall 2013, Andrew has been working within Percona's Remote DBA team plying his experience to the client's environments and internal tools developed to keep operations slick.


In this talk we'll take a deep dive into the popular iostat and pt-diskstats tools and look at how they can be used to monitor performance on Linux. We'll look at the options associated with the tools to understand how they influence behavior, the kernel metadata they both use as a basis for their calculations, and review the source code to understand the metrics that they report... [read more]
Join Jeremy Glick and Andrew Moore whilst they share their experiences persuading MySQL to meet various regulatory compliance standards. Previous methods of logging for compliance included UDFs, triggers and other unreliable means to fill a gap in the core offering. However, given some of today's new requirements, they are no longer viable solutions. Did you know that MySQL has had a... [read more]