Back To Schedule
Wednesday, October 21 • 02:30 - 03:00
Vitess Online Schema Migration Automation

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

For many, running an online schema migration operation is still a manual job: from building the correct command, through identifying where the migration should run and which servers are to be affected, to auditing progress and completing the migration. Sharded environment poses an additional burden, as any logical migration must be applied multiple times, once for each shard.

What if you could just issue an ALTER TABLE ... statement, and have all that complexity automated away?
Vitess, an open source sharding framework for MySQL, is in a unique position to do just that. This session shows how Vitess's proxy/agent/topology architecture, together with gh-ost, are used to hide schema change complexity, and carefully schedule and apply schema migrations.

avatar for Shlomi Noach

Shlomi Noach

Engineer, PlanetScale
Engineer and database geek, works at PlanetScale as a maintainer for open source Vitess. Previously at GitHub. Interested in database infrastructure solutions such as high availability, reliability, enablement, automation and testing. Shlomi is an active MySQL community member, authors... Read More →

avatar for Evgeniy Patlan

Evgeniy Patlan

Sr. Build / Release Engineer, Percona

Wednesday October 21, 2020 02:30 - 03:00 EDT
  • Difficulty Intermediate
  • Why this level of difficulty? The session will appeal to people who have experiences the pains of running schema migrations. However, it is not too deep technically (e.g. no source code analysis involved).
  • Speaker Location Israel