github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/case_sensitive/conf/dm-task.yaml (about)

     1  ---
     2  name: test
     3  task-mode: all
     4  is-sharding: false
     5  meta-schema: "dm_meta"
     6  heartbeat-update-interval: 1
     7  heartbeat-report-interval: 1
     8  case-sensitive: true
     9  
    10  target-database:
    11    host: "127.0.0.1"
    12    port: 4000
    13    user: "root"
    14    password: ""
    15    session:
    16      tidb_skip_utf8_check: 1
    17      tidb_disable_txn_auto_retry: off
    18      tidb_retry_limit: "10"
    19  
    20  mysql-instances:
    21    - source-id: "mysql-replica-01"
    22      black-white-list:  "instance" # compatible with deprecated config
    23      mydumper-config-name: "global"
    24      loader-config-name: "global"
    25      syncer-config-name: "global"
    26      route-rules: ["global"]
    27      filter-rules: ["global"]
    28  
    29    - source-id: "mysql-replica-02"
    30      block-allow-list:  "instance"
    31      mydumper-config-name: "global"
    32      loader-config-name: "global"
    33      syncer-config-name: "global"
    34      route-rules: ["global"]
    35      filter-rules: ["global"]
    36  
    37  black-white-list: # compatible with deprecated config
    38    instance:
    39      do-dbs: ["Upper_DB*", "lower_db"]
    40      do-tables:
    41        - db-name: "Upper_DB*"
    42          tbl-name: "Do_Table*"
    43        - db-name: "Upper_DB"
    44          tbl-name: "lower_table*"
    45        - db-name: "lower_db"
    46          tbl-name: "Upper_Table*"
    47  
    48  routes:
    49    global:
    50      schema-pattern: "Upper_DB"
    51      table-pattern: "Do_Table"
    52      target-schema: "UPPER_DB_ROUTE"
    53      target-table: "do_table_route"
    54  
    55  filters:
    56    global:
    57      schema-pattern: "Upper_DB*"
    58      table-pattern: "Do_Table*"
    59      events: ["truncate table"]
    60      action: Ignore
    61  
    62  mydumpers:
    63    global:
    64      threads: 4
    65      chunk-filesize: 64
    66      skip-tz-utc: true
    67      extra-args: ""
    68  
    69  loaders:
    70    global:
    71      pool-size: 16
    72      dir: "./dumped_data"
    73  
    74  syncers:
    75    global:
    76      worker-count: 16
    77      batch: 100
    78      enable-ansi-quotes: false  # compatible with deprecated config