Vitess VReplication: Standing on the Shoulders of a MySQL Giant
summary
Vitess VReplication claims to move and keep large MySQL datasets consistent while reshaping them: it copies rows with a row streamer snapshot phase, then applies ongoing changes via a binlog streamer into target shards where changes become SQL and are applied by VCopier/VAplier. It powers online resharding, materialized views, CDC and online DDL used by PlanetScale, supports MySQL 5.7/8 (MariaDB likely deprecated), and verifies results with vdiff before switching traffic.
AI-written summary · about
chapters (13)
- 0:00Start
- 2:32Cloud Native
- 9:52Query Consolidation
- 14:50Scatter Gather Query
- 20:27Vt Admin
- 21:49V Replication
- 25:23Move Tables Operation
- 28:03Row Streamer
- 28:33Running Mode
- 31:58Routing Rules
- 35:03Vertical Sharding
- 38:01Materialize Views
- 39:39Messaging
