Vitess Online Resharding With VSchema and VReplication
Vitess online resharding changes sharding via VSchema and VReplication, using SplitClone for initial copy and controlled cut-over to new shards without downtime.
Loading…
ReadMeFeed / Community knowledge
#vreplication
Real questions. Useful conversations. Find the people who know your stack.
vitessOnline 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.
Managing Database Growth with Vitess VReplication
Learn how Vitess uses VReplication to perform online resharding, moving data between MySQL shards without downtime using binlog streaming and a structured cutover process.
Online DDL in Vitess 16+: choosing between vitess, gh-ost, and pt-osc strategies for large sharded tables
Context Vitess Online DDL supports managed, non-blocking schema migrations through several strategies: the built-in vitess (VReplication-based) strategy, plus orchestrated gh-ost and pt-osc . The strategy is selected per migration, for example via @@ddl_strategy or the ApplySchema DDL strategy flag. Documentation for recent major releases (16 and later) desc
VReplication resharding cut-over: managing conflicting updates during final synchronization
Resharding Consistency in Vitess Vitess utilizes VReplication to move data asynchronously between sources and destinations during resharding operations. This workflow ensures that the target shards are populated while the source remains available for writes. The final cut-over phase requires a brief write-lock on the source to synchronize the remaining binlo