Brian Cain

Brian Cain

Brian Cain

Senior Data Infrastructure Engineer, SurveyMonkey


Brian is a Database Engineer at SurveyMonkey. He has worked with MySQL for the past 6 years supporting multiple client environments as a consultant or FTE. He spends most of his time as an operational DBA automating routine tasks such as instance cloning and master promotions along with enhancing monitoring and alerts to proactively detect upcoming issues. He has a background as a developer, manager, and systems administrator over the past 20+ years. Brian is based out of Seattle, WA.

All Sessions

MySQL Schema Migrations: Exploring the Options

Table migrations remain a pain point for MySQL DBAs. There are more options than ever for running migrations, with the later versions' in-place alters and new third-party tools (like gh-ost). But with the increase in tools and procedures it's been shown that there is no one-size-fits-all tool. Depending on the table size, available disk space, database traffic, server performance and SLAs, some migration methods make more sense than others.

In this tutorial we will discuss and demonstrate the different tools and methods and the best practices and scenarios for each.

Optional Lab Requirements:
- MacOS or Linux laptop (or VM)
- MySQL Sandbox, Percona Toolkit, gh-ost, sysbench
- MySQL 5.7 generic binary (for MySQL Sandbox)


Migration Concepts and Types
- Straight and in-place ALTER TABLE
- Alter on replicas, then promote
- pt-online-schema-change
- gh-ost

Caveats and Best Practices

- Test each of the migration types in a database cluster

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863