Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Online schema changes for maximizing uptime

Online schema changes for maximizing uptime

 27 April - 3:00 PM - 3:50 PM @ Ballroom D
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Topics:
MySQL
Tools and Techniques

Description

Whether adding indexes, altering enums, changing datatypes or reorganizing tables - there are right and wrong ways when production is involved. In this session, we will go over common operations implemented in production, discuss their impacts, and appropriate strategies for minimizing downtime and customer impact to systems. * Fast operations including index adds and enum list changes (and gotchas!) * Online schema changes using current production utilities * Rolling Migrations and Upgrades * Impacts of replication on DDL changes * Things to look out for when changing your schemas. * RDS MySQL and Aurora

Speakers

Ben Black's picture

Ben Black

DBA, Tango

Biography:

For the past 15 years, Ben has been a DBA, developer, and Sys Admin working on high volume production systems at Garmin, PalominoDB, and Tango.

David Turner's picture

David Turner

Storage SRE, Uber

Biography:

David Turner joined Uber in 2016. He has more than 10 years experience working with databases such as Oracle and MySQL. He was drawn to MySQL because of his interest in database internals and a deeper understanding of systems architecture. With MySQL he has found he has more freedom to explore. His experience in working at larger shops such as Dropbox, Facebook, Pinterest, Sprint, and Zendesk has given him a strong understanding of scaling issues and of managing massive amounts of data and databases.

Share this talk