github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/dmctl_basic/conf/dm-task4.yaml (about)

     1  ---
     2  name: pre_check_optimistic
     3  task-mode: all
     4  shard-mode: "optimistic"
     5  meta-schema: "dm_meta"
     6  enable-heartbeat: false
     7  
     8  target-database:
     9    host: "127.0.0.1"
    10    port: 4000
    11    user: "root"
    12    password: ""
    13  
    14  mysql-instances:
    15    - source-id: "mysql-replica-01"
    16      block-allow-list:  "instance"
    17      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    18      mydumper-config-name: "global"
    19      loader-config-name: "global"
    20      syncer-config-name: "global"
    21  
    22    - source-id: "mysql-replica-02"
    23      block-allow-list:  "instance"
    24      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    25      mydumper-config-name: "global"
    26      loader-config-name: "global"
    27      syncer-config-name: "global"
    28  
    29  block-allow-list:
    30    instance:
    31      do-dbs: ["dmctl"]
    32      do-tables:
    33      -  db-name: "dmctl"
    34         tbl-name: "~^precheck_optimistic_tb_[\\d]+"
    35  
    36  routes:
    37    sharding-route-rules-table:
    38      schema-pattern: dmctl
    39      table-pattern: precheck_optimistic_tb_*
    40      target-schema: dmctl
    41      target-table: precheck_optimistic_tb
    42  
    43    sharding-route-rules-schema:
    44      schema-pattern: dmctl
    45      target-schema: dmctl
    46  
    47  mydumpers:
    48    global:
    49      threads: 4
    50      chunk-filesize: 64
    51      skip-tz-utc: true
    52      extra-args: ""
    53  
    54  loaders:
    55    global:
    56      pool-size: 16
    57      dir: "./dumped_data"
    58  
    59  syncers:
    60    global:
    61      worker-count: 16
    62      batch: 100
    63      checkpoint-flush-interval: 1