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

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