github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/shardddl1/conf/double-source-pessimistic.yaml (about)

     1  ---
     2  name: test
     3  task-mode: all
     4  is-sharding: true
     5  shard-mode: "pessimistic"
     6  meta-schema: "dm_meta"
     7  
     8  target-database:
     9    host: "127.0.0.1"
    10    port: 4000
    11    user: "test"
    12    password: '123456'
    13  
    14  mysql-instances:
    15    - source-id: "mysql-replica-01"
    16      block-allow-list:  "instance"
    17      route-rules: ["sharding-table-rules","sharding-schema-rules"]
    18      mydumper-config-name: "global"
    19      loader-config-name: "global"
    20      syncer-config-name: "global"
    21    - source-id: "mysql-replica-02"
    22      block-allow-list:  "instance"
    23      route-rules: ["sharding-table-rules","sharding-schema-rules"]
    24      mydumper-config-name: "global"
    25      loader-config-name: "global"
    26      syncer-config-name: "global"
    27  
    28  block-allow-list:
    29    instance:
    30      do-dbs: ["shardddl1","shardddl2"]
    31  
    32  routes:
    33    sharding-table-rules:
    34      schema-pattern: "shardddl*"
    35      target-schema: "shardddl"
    36      table-pattern: "tb*"
    37      target-table: "tb"
    38    sharding-schema-rules:
    39      schema-pattern: "shardddl*"
    40      target-schema: "shardddl"
    41  
    42  mydumpers:
    43    global:
    44      threads: 4
    45      chunk-filesize: 64
    46      skip-tz-utc: true
    47      extra-args: ""
    48  
    49  loaders:
    50    global:
    51      pool-size: 16
    52      dir: "./dumped_data"
    53  
    54  syncers:
    55    global:
    56      worker-count: 16
    57      batch: 100