VDiff create

vtctldclient VDiff create

Create and run a VDiff to compare the tables involved in a VReplication workflow between the source and target.

  1. vtctldclient VDiff create

Examples

  1. vtctldclient --server localhost:15999 vdiff --workflow commerce2customer --target-keyspace customer create
  2. vtctldclient --server localhost:15999 vdiff --workflow commerce2customer --target-keyspace customer create b3f59678-5241-11ee-be56-0242ac120002

Options

  1.       --auto-retry                                Should this vdiff automatically retry and continue in case of recoverable errors. (default true)
  2.       --debug-query                               Adds a mysql query to the report that can be used for further debugging.
  3.       --filtered-replication-wait-time duration   Specifies the maximum time to wait, in seconds, for replication to catch up when syncing tablet streams. (default 30s)
  4.   -h, --help                                      help for create
  5.       --limit uint32                              Max rows to stop comparing after. (default 4294967295)
  6.       --max-extra-rows-to-compare uint32          If there are collation differences between the source and target, you can have rows that are identical but simply returned in a different order from MySQL. We will do a second pass to compare the rows for any actual differences in this case and this flag allows you to control the resources used for this operation. (default 1000)
  7.       --only-pks                                  When reporting missing rows, only show primary keys in the report.
  8.       --source-cells strings                      The source cell(s) to compare from; default is any available cell.
  9.       --tables strings                            Only run vdiff for these tables in the workflow.
  10.       --tablet-types strings                      Tablet types to use on the source and target.
  11.       --tablet-types-in-preference-order          When performing source tablet selection, look for candidates in the type order as they are listed in the tablet-types flag. (default true)
  12.       --target-cells strings                      The target cell(s) to compare with; default is any available cell.
  13.       --update-table-stats                        Update the table statistics, using ANALYZE TABLE, on each table involved in the VDiff during initialization. This will ensure that progress estimates are as accurate as possible -- but it does involve locks and can potentially impact query processing on the target keyspace.
  14.       --wait                                      When creating or resuming a vdiff, wait for it to finish before exiting.
  15.       --wait-update-interval duration             When waiting on a vdiff to finish, check and display the current status this often. (default 1m0s)

Options inherited from parent commands

  1.       --action_timeout duration   timeout to use for the command (default 1h0m0s)
  2.       --compact                   use compact format for otherwise verbose outputs
  3.       --format string             The format of the output; supported formats are: text,json. (default "text")
  4.       --server string             server to use for the connection (required)
  5.       --target-keyspace string    Target keyspace for this workflow.
  6.   -w, --workflow string           The workflow you want to perform the command on.

SEE ALSO

  • vtctldclient VDiff - Perform commands related to diffing tables involved in a VReplication workflow between the source and target.