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 to choose between INSTANT, INPLACE, and COPY algorithms in MariaDB to perform schema changes on InnoDB tables without causing application downtime.
Learn how to add a column to an InnoDB table with MySQL’s online DDL, allowing concurrent writes, monitoring progress, and recovering if the operation needs more log space.
The goal is to guarantee that a schema change applied via YugabyteDB's online DDL can be safely reverted if the migration has only progressed on a subset of tablets, without risking data loss or inconsistency. Currently, once a background migration starts altering tablets, there is no built‑in mechanism to roll back those tablets to the previous schema; cert