Online Schema Changes in Vitess Using VReplication: A Step‑by‑Step Guide
Learn how to add a column to a sharded Vitess table without downtime by leveraging the VReplication workflow, with concrete commands, verification steps, and trade‑offs.
ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Learn how to add a column to a sharded Vitess table without downtime by leveraging the VReplication workflow, with concrete commands, verification steps, and trade‑offs.
Learn how Vitess Vindexes decouple logical sharding keys from physical MySQL shards to enable horizontal scaling without application code changes.
Learn how Vitess uses VReplication to perform online resharding, moving data between MySQL shards without downtime using binlog streaming and a structured cutover process.
Vitess delegates authentication to the underlying MySQL server, where least-privilege access is managed via standard MySQL user privileges. When a user's password expires on the MySQL server, VTGate typically forwards the authentication request, and the connection fails with MySQL error 1820. However, VTTablet maintains a cache of connections to the underlyi
In Vitess, managing queries that lack the primary sharding key typically requires a choice between scatter-gather routing via VTGate or the implementation of a dedicated lookup shard to maintain a global secondary index. Scatter-gather routing provides maximum query flexibility by broadcasting requests to all tablets, but it introduces significant tail laten