Loading…
Attending this event?
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!

Log in to leave feedback.


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.

Speakers
avatar for Shlomi Noach

Shlomi Noach

Engineer, PlanetScale
Engineer and database geek, working at PlanetScale on both open source Vitess as well as PlanetScaleDB. Interested in database infrastructure solutions such as high availability, reliability, enablement, automation and testing.Shlomi is an active MySQL community member, authors orchestrator... Read More →

Hosts
avatar for Evgeniy Patlan

Evgeniy Patlan

Sr. Build / Release Engineer, Percona



Wednesday October 21, 2020 02:30 - 03:00 EDT
Online
  MySQL
  • 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