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

pt-table-sync support for MyRocks

Details

    • Improvement
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 3.0.6
    • None

    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
      

      Attachments

        Activity

          People

            carlos.salguero Carlos Salguero (Inactive)
            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

                Smart Checklist