Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-221

pt-table-sync support for MyRocks

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.6
    • Component/s: None
    • Labels:

      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

      plavi@bender  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*/;
      ...
      plavi@bender  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
      
      plavi@bender  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

      plavi@bender  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
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              carlos.salguero Carlos Salguero
              Reporter:
              tomislav.plavcic@percona.com Tomislav Plavcic
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days
                  3d