SwitchWrites
Route writes to target keyspace in a vreplication workflow
Starting with Vitess 11.0 you should use the SwitchTraffic VReplication v2 commands
Command #
SwitchWrites -- [--timeout=30s] [--cancel] [--reverse] [--reverse_replication=false] --tablet_types=primary [--dry-run] <keyspace.workflow>
Description #
SwitchWrites is used to switch writes for tables in a MoveTables workflow or for entire keyspace in the Reshard workflow away from the primary in the source keyspace to the primary in the target keyspace
Parameters #
--timeout #
optional
default 30s
Specifies the maximum time to wait, in seconds, for vreplication to catch up on primary migrations. The migration will be cancelled on a timeout.
--filtered_replication_wait_time #
DEPRECATED
default 30s
SwitchWrites first stops writes on the source primary and waits for the replication to the target to
catchup with the point where the writes were stopped. If the wait time is longer than filtered_replication_wait_time
the command will error out.
For setups with high write qps you may need to increase this value.
--cancel #
optional
default false
If a previous SwitchWrites returned with an error you can restart it by running the command again (after fixing
the issue that caused the failure) or the SwitchWrites can be canceled using this parameter. Only the SwitchWrites
is cancelled: the workflow is set to Running so that replication continues.
--reverse #
optional
default false
Reverse a previous SwitchWrites serve from source
--reverse_replication #
optional
default true
SwitchWrites, by default, starts a reverse replication stream with the current target as the source, replicating
back to the original source. This enables a quick and simple rollback. This reverse workflow name is that
of the original workflow concatenated with \_reverse.
--tablet_types #
mandatory
Tablet types to switch traffic for. For writes that will only be primary tablets.
Note: For tablet type rdonly you must [SwitchReads](../switchreads) before you can SwitchWrites
--dry-run #
optional
default false
You can do a dry run where no actual action is taken but the command logs all the actions that would be taken
by SwitchWrites.
keyspace.workflow #
mandatory
Name of target keyspace and the associated workflow to SwitchWrites for.
SwitchWrites