github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/handle_error_3/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-rules1","sharding-table-rules2"]
    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-rules1","sharding-table-rules2"]
    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: ["handle_error"]
    31  
    32  routes:
    33    sharding-table-rules1:
    34      schema-pattern: "handle_error"
    35      target-schema: "handle_error"
    36      table-pattern: "tb*"
    37      target-table: "tb"
    38    sharding-table-rules2:
    39      schema-pattern: "handle_error"
    40      target-schema: "handle_error"
    41      table-pattern: "ta*"
    42      target-table: "ta"
    43  
    44  mydumpers:
    45    global:
    46      threads: 4
    47      chunk-filesize: 64
    48      skip-tz-utc: true
    49      extra-args: ""
    50  
    51  loaders:
    52    global:
    53      pool-size: 16
    54      dir: "./dumped_data"
    55  
    56  syncers:
    57    global:
    58      worker-count: 16
    59      batch: 100