VExec

Wrapper on VReplicationExec to run query on all participating masters

Command

VExec  [-dry_run] <keyspace.workflow> <query>

Description

VExec is a wrapper over VReplicationExec. Given a workflow it executes the provided query on all masters in the target keyspace that participate in the workflow. Internally it calls VReplicationExec for running the query.

Parameters

-dry-run

optional
default false

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.

keyspace.workflow

mandatory

Name of target keyspace and the associated workflow

sql query

mandatory

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.

Example

vtctlclient VExec keyspace1.workflow1 'select * from _vt.vreplication'