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

     1  ---
     2  name: test
     3  task-mode: all
     4  is-sharding: true
     5  shard-mode: "optimistic"
     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-02"
    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  
    22  block-allow-list:
    23    instance:
    24      do-dbs: ["shardddl1","shardddl2"]
    25  
    26  routes:
    27    sharding-table-rules:
    28      schema-pattern: "shardddl*"
    29      target-schema: "shardddl"
    30      table-pattern: "tb*"
    31      target-table: "tb"
    32    sharding-schema-rules:
    33      schema-pattern: "shardddl*"
    34      target-schema: "shardddl"
    35  
    36  mydumpers:
    37    global:
    38      threads: 4
    39      chunk-filesize: 64
    40      skip-tz-utc: true
    41      extra-args: ""
    42  
    43  loaders:
    44    global:
    45      pool-size: 16
    46      dir: "./dumped_data"
    47  
    48  syncers:
    49    global:
    50      worker-count: 16
    51      batch: 100