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.