VReplicationExec

Low level command to run a query on vreplication related tables

This command was deprecated in v16.0 and will be removed in a future release.

Command

  1. VReplicationExec -- [--json] <tablet_alias> <query>

Description

The VReplicationExec command is used to view or manage vreplication streams. You would typically use one of the higher-level commands like the WorkFlow command accomplish the same task.

Parameters

--json

optional

The output of the command is json formatted: to be readable by scripts.

tablet_alias

mandatory

Id of the target tablet on which to run the sql query, specified using the vitess tablet id format <cell>-<uid> (see example below).

query

mandatory

SQL query which will be run: validations are done to ensure that queries can be run only against vreplication tables. A limited set of queries are allowed.

Example

  1. vtctlclient VReplicationExec 'zone1-100' 'select * from _vt.vreplication'