Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Let Robots Manage your Schema (without destroying all humans)

Let Robots Manage your Schema (without destroying all humans)

 19 April 02:20 PM - 3:10 PM @ Ballroom G
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Development
Operations and Management
Topics:
Other
Devops
Tools and Techniques

Description

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.

Speakers

Jenni Snyder's picture

Jenni Snyder

MySQL DBA, Yelp

Biography:

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.

Share this talk


Slides