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

     1  ---
     2  name: test
     3  task-mode: all
     4  is-sharding: false
     5  meta-schema: "dm_meta"
     6  # enable-heartbeat: true
     7  heartbeat-update-interval: 1
     8  heartbeat-report-interval: 1
     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      filter-rules: ["user-filter-1"]
    27  
    28    - source-id: "mysql-replica-02"
    29      block-allow-list:  "instance"
    30      mydumper-config-name: "global"
    31      loader-config-name: "global"
    32      syncer-config-name: "global"
    33      filter-rules: ["user-filter-1"]
    34  
    35  black-white-list: # compatible with deprecated config
    36    instance:
    37      do-dbs: ["lightning_mode"]
    38      ignore-dbs: ["ignore_db"]
    39  
    40  filters:                     # filter rules, mysql instance can ref rules in it
    41    user-filter-1:
    42      schema-pattern: "*"    # pattern of the upstream schema name, wildcard characters (*?) are supported
    43      table-pattern: "*"        # pattern of the upstream table name, wildcard characters (*?) are supported
    44      events: ["truncate table", "drop table"]  # ignore truncate/drop table ddl
    45      action: Ignore
    46  
    47  mydumpers:
    48    global:
    49      threads: 4
    50      chunk-filesize: 64
    51      skip-tz-utc: true
    52      extra-args: ""
    53  
    54  loaders:
    55    global:
    56      pool-size: 16
    57      dir: "./dumped_data"
    58      import-mode: "physical"
    59      on-duplicate-physical: "manual"
    60  
    61  syncers:
    62    global:
    63      worker-count: 16
    64      batch: 100
    65      enable-ansi-quotes: false  # compatible with deprecated config