Let Robots Manage your Schema (without destroying all humans)
You're probably already using automation to build your application, manage configuration, and alert you in case of emergencies. What's keeping you from doing the same with your MySQL schema changes? For us, the answer was "lots of things". Today, Yelp uses Liquibase to manage our schema changes, pt-online-schema-change to execute them, and Jenkins to ensure that they're run in all of our environments. During this session, I'll explain the history of MySQL schema management at Yelp, and how hard it was for both developers and DBAs. You’ll learn how we evaluated and decided on the combination of open-source tools we chose, as well as how we rolled this change in process with minimal disruption.
MySQL DBA, Yelp
Jenni has been a MySQL DBA for over ten years, and spending the last four and a half here at Yelp. She loves how easy it is to start with MySQL, the performance and tuning options, and the Community around it that welcomes new members. Her favorite aspects of MySQL DBA work are finding & eliminating bottlenecks, InnoDB tuning, optimizing slow queries, eliminating deadlocks, and helping developers.