How to shard MariaDB like a Pro
summary
Vitess proves it can manage MariaDB sharding end to end: a local Docker demo runs against MariaDB 10.3 with etcd as topo, bringing up tablets and proxies, creating sequences for autoincrement, creating shards, running vtctlclient MoveTables, then switching reads and writes via vtgate/vtctld/vtctlclient to complete a live reshard from an unsharded commerce keyspace into a sharded customer keyspace, deleting the old tablets; the migration finishes successfully without changing mysqld.
AI-written summary · about
chapters (12)
- 0:00Introduction and speaker background
- 1:56What is Vitess and its architecture
- 8:10Supported databases and engines
- 9:23Vitess use cases and sharding
- 11:40MariaDB compatibility and resources
- 12:30Demo setup and local Docker image
- 15:16Initializing and migrating to customer keyspace
- 16:59Switching reads to new keyspace
- 18:17Switching writes to new keyspace
- 19:31Sharding the customer keyspace
- 22:47Resharding and final migration
- 24:16Summary and resources
