Wrapper on VReplicationExec to run query on all participating primary tablets
This command was deprecated in v12.0 and has been removed in v16.0.
VExec -- [--dry_run] <keyspace.workflow> <query>
VExec is a wrapper over VReplicationExec. Given a workflow it executes the provided query on all primary tablets in the target keyspace that participate in the workflow. Internally it calls VReplicationExec for running the query.
You can do a dry run where no actual action is taken but the command logs the queries and the tablets on which the query would be run. by VExec.
Name of target keyspace and the associated workflow
SQL query to be run: validations are done to ensure that queries can be run only against vreplication tables. A limited set of queries are allowed.
vtctlclient VExec keyspace1.workflow1 'select * from _vt.vreplication'