Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Wednesday, May 12 • 08:00 - 08:30
Revertible, Recoverable Schema Migrations in Vitess

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


Recent developments in Vitess take online schema migrations to a new level, allowing us to think of DDLs as little more than a transaction, giving both developers and DBAs new super powers and peace of mind.

- Have you ever completed a schema migration only to realize a column should not have been dropped, an index should not have changed?
- Have you ever dropped a table only to find it was a big mistake?
- Have you ever waited a week for a schema migration, only to see it go down the drain due to a failover? Or have you postponed important maintenance work due to a running migration?

Vitess online schema migrations now utilize _VReplication_, a core component in Vitess that empowers Vitess’s live resharding, materialized views, live imports, and more.

In this session we present VReplication and illustrate how it works. We follow up to explain how online schema changes employ VReplication for both revertible, and recoverable, lossless schema migrations. We will discuss some of the internal logic, and present a demo of these new super powers.

Vitess is a CNCF open source database clustering system for horizontal scaling of MySQL.

Speakers
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 →


Wednesday May 12, 2021 08:00 - 08:30 EDT
Room #1
Feedback form isn't open yet.