Technology · Ebook

Vitess: Scaling MySQL Horizontally

by Shriira Press

Vitess is a database clustering system that makes MySQL scale horizontally: it sits in front of many MySQL instances and presents them as one large database, handling sharding, routing, and operations — so you scale MySQL massively while keeping the MySQL you know. This free book teaches it from the ground up: the MySQL scaling problem and sharding fundamentals, Vitess's architecture (VTGate, VTTablet, topology, vtctld), keyspaces/shards and the data model, query routing and the VSchema with vindexes, online resharding with VReplication (zero downtime), connection pooling and transactions, high availability/failover/backups, Vitess on Kubernetes and the ecosystem (MySQL compatibility, PlanetScale), and operating Vitess in production. Ten focused chapters with clear diagrams that show how Vitess scales MySQL transparently — sharding, resharding online, and clustering — without giving up MySQL.

Contents

1. 1Preface
2. 2Chapter 1 — What Vitess Is
3. 3Chapter 2 — Database Sharding Fundamentals
4. 4Chapter 3 — Architecture
5. 5Chapter 4 — Keyspaces, Shards, and the Data Model
6. 6Chapter 5 — Query Routing and the VSchema
7. 7Chapter 6 — Resharding
8. 8Chapter 7 — Connection Management and Transactions
9. 9Chapter 8 — High Availability, Failover, and Backups
10. 10Chapter 9 — Vitess on Kubernetes and the Ecosystem
11. 11Chapter 10 — Operating Vitess and Putting It Together