Vitess: Running MySQL with confidence on Kubernetes
summary
Claim: running MySQL on Kubernetes works well when using Vitess to provide clustering, sharding and automated HA. The demo builds a full Kubernetes deployment with Vitess operator by PlanetScale, vtgate/vttablet/vtctld, a topology service (etcd), orchestrator for automatic reparenting, and S3 backups. The demo scales read replicas from 1 upward, live migrates a large customers table into a new keyspace without downtime, restores new tablets from backups, and shows failover and query routing working end to end.
AI-written summary · about
chapters (20)
- 0:00Introduction and speaker intro
- 2:10MySQL on Kubernetes dilemma
- 4:38Option one direct MySQL in pod
- 5:44Option two MySQL with PVC
- 7:09Option three MySQL replication
- 9:16Introducing Vitess
- 10:59How Vitess architecture works
- 13:45Vitess benefits and features
- 15:31Demo scaling with Vitess
- 17:59Live Kubernetes cluster setup
- 19:45Vitess cluster components
- 20:30Data import and queries
- 21:10Connection strings and routing
- 22:20Adding a replica
- 23:22Application demo with Vitess
- 24:26Scaling out read traffic
- 24:48Creating new keyspace
- 25:55Moving table between keyspaces
- 28:24Finalizing table migration
- 29:28Conclusion and answer
related talks
43mVitess and a Kubernetes Operator
35mExploring High Availability in Kubernetes with Vitess
05mRun Your Data Layer In K8s With Vitess
38mIntro: Vitess
45mDeep Dive: Vitess
34mInside Vitess: Building Resilient, Distributed Databases
12mKeynote: Keeping Your Data in Kubernetes with Vitess
35mExploring High Availability in Kubernetes with Vitess