cmd.sh

vtctl MoveTables -cells=etsy_cells -workflow=ks2to3_workflow ks2 ks3 'ks2to3_test'
vtctl SwitchReads -tablet_type=rdonly ks3.ks2to3_workflow
vtctl SwitchReads -tablet_type=replica ks3.ks2to3_workflow
vtctl SwitchWrites ks3.ks2to3_workflow
vtctl SwitchReads -tablet_type=rdonly ks2.ks2to3_workflow_reverse
vtctl SwitchReads -tablet_type=replica ks2.ks2to3_workflow_reverse
vtctl_etsy SwitchWrites ks2.ks2to3_workflow_reverse
# after executing the previous command, i *think* that `select * from _vt.vreplication\G` might show non-fully qualified vindex names in the in_keyrange clause...

ks1_test.sql

CREATE TABLE `ks1_test` (
  `k` bigint(20) NOT NULL,
  `v` bigint(20) NOT NULL,
  PRIMARY KEY (`k`, `v`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

ks1_vschema.json

{
    "sharded": true,
    "vindexes": {
        "hash": {
            "type": "hash"
        }
    },
    "tables": {
        "ks1_test": { "column_vindexes": [ { "name": "hash", "column": "k" } ] }
    }
}

ks2_test.sql

CREATE TABLE `ks2to3_test` (
  `k` bigint(20) NOT NULL,
  `v` bigint(20) NOT NULL,
  PRIMARY KEY (`k`, `v`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

ks3_test.sql

CREATE TABLE `ks2to3_test` (
  `k` bigint(20) NOT NULL,
  `v` bigint(20) NOT NULL,
  PRIMARY KEY (`k`, `v`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

ks3_vschema.json

{
    "sharded": true,
    "vindexes": {
        "hash": {
            "type": "hash"
        }
    },
    "tables": {
        "ks2to3_test": { "column_vindexes": [ { "name": "hash", "column": "k" } ] }
    }
}