Mark Filipi

Mark Filipi

Mark Filipi

Senior Database Administrator, SurveyMonkey

Biography:

Mark's role at SurveyMonkey spans a variety of applications and users that utilize MySQL. Previously at PalominoDB, he worked on everything from startups to video games to presidential elections.


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)

Agenda:

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

Lab
- 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(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863