Geo-partitioning with Vitess
Talkat KubeCon + CloudNativeCon North America 2019 · on Wednesday, 2019-11-20· at 14:25· Room 6D - San Diego Convention Center, Upper Level·
summary
Shows a working Vitess cluster on GKE that enforces data residency by mapping country bytes to shard ranges, using a custom multi-column region Vindex that stores ID+country → keyspace_id in a lookup table. VTGate is deployed per region and routes writes so 16 sample rows land in the correct shards; the demo uses four shards across four cells and an unsharded lookup keyspace. No application changes are required because VTGate handles routing.
AI-written summary · about
chapters (9)
- 0:00Introduction to Vitess
- 1:40The problem and solution
- 3:49Vitess architecture concepts
- 6:30Vindex and sharding functions
- 12:55Modeling jurisdictional data
- 15:33Demo setup and schema
- 21:35Schema deployment and insert
- 29:45Data verification
- 35:06Q&A and conclusion
related talks
30mSo You Want to Geo-Partition Your Data... - Deepthi Sigireddi & Jiten Vaidya, Planetscale, Inc.
34mSo You Want to Geo-Partition Your Data...
35mExploring High Availability in Kubernetes with Vitess
34mInside Vitess: Building Resilient, Distributed Databases
35mExploring High Availability in Kubernetes with Vitess
45mDeep Dive: Vitess
43mVitess and a Kubernetes Operator
44mIntro: Vitess
