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

     1  ---
     2  name: test
     3  task-mode: all
     4  is-sharding: true
     5  shard-mode: "optimistic"
     6  meta-schema: "dm_meta"
     7  ignore-checking-items: ["auto_increment_ID"]
     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    - source-id: "mysql-replica-02"
    23      block-allow-list:  "instance"
    24      route-rules: ["sharding-table-rules","sharding-schema-rules"]
    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: ["shardddl1","shardddl2"]
    32  
    33  routes:
    34    sharding-table-rules:
    35      schema-pattern: "shardddl*"
    36      target-schema: "shardddl"
    37      table-pattern: "tb*"
    38      target-table: "tb"
    39    sharding-schema-rules:
    40      schema-pattern: "shardddl*"
    41      target-schema: "shardddl"
    42  
    43  mydumpers:
    44    global:
    45      threads: 4
    46      chunk-filesize: 64
    47      skip-tz-utc: true
    48      extra-args: ""
    49  
    50  loaders:
    51    global:
    52      pool-size: 16
    53      dir: "./dumped_data"
    54  
    55  syncers:
    56    global:
    57      worker-count: 16
    58      batch: 100