Description
Just checked pt-table-sync with MyRocks and here's my findings.
1. It seems to work without problems when MyRocks tables are synced between independent hosts
[email protected] msb_5_7_19 pt-table-sync --print h=127.0.0.1,P=20594,u=msandbox,p=msandbox h=127.0.0.1,P=5719,u=msandbox,p=msandbox --databases world_rocksdb INSERT INTO `world_rocksdb`.`City`(`id`, `name`, `countrycode`, `district`, `population`) VALUES ('4001', 'Gilbert', 'USA', 'Arizona', '109697') /*percona-toolkit src_db:world_rocksdb src_tbl:City src_dsn :P=20594,h=127.0.0.1,p=...,u=msandbox dst_db:world_rocksdb dst_tbl:City dst_dsn:P=5719,h=127.0.0.1,p=...,u=msandbox lock:0 transaction:0 changing_src:0 replicate:0 bidirectional:0 pid:22782 user:plavi hos t:bender*/; ... [email protected] msb_5_7_19 pt-table-sync --exec h=127.0.0.1,P=20594,u=msandbox,p=msandbox h=127.0.0.1,P=5719,u=msandbox,p=msandbox --databases world_rocksdb [email protected] msb_5_7_19 pt-table-sync --print h=127.0.0.1,P=20594,u=msandbox,p=msandbox h=127.0.0.1,P=5719,u=msandbox,p=msandbox --databases world_rocksdb
2. --replicate option won't work because it uses checksum table from pt-table-checksum which doesn't support MyRocks (PT-204)
3. --sync-to-master option fails with below so most probably it won't be supported
[email protected] msb_5_7_19 pt-table-sync --print --sync-to-master h=127.0.0.1,P=20595,u=msandbox,p=msandbox --databases world_rocksdb Can't execute updates on master with binlog_format != ROW. [for Statement "LOCK TABLES `world_rocksdb`.`City` WRITE"] at line 6139 while doing world_rocksdb.City on 127.0.0.1 Can't execute updates on master with binlog_format != ROW. [for Statement "LOCK TABLES `world_rocksdb`.`Country` WRITE"] at line 6139 while doing world_rocksdb.Country on 127.0.0.1 Can't execute updates on master with binlog_format != ROW. [for Statement "LOCK TABLES `world_rocksdb`.`CountryLanguage` WRITE"] at line 6139 while doing world_rocksdb.CountryLanguage on 127.0.0.1