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

     1  ---
     2  name: "task_pessimistic"
     3  task-mode: all
     4  shard-mode: pessimistic
     5  # Display width specification for integer data types was deprecated in MySQL 8.0.17
     6  # create table tb(a int(12)) will be `int` in mysql:8.0.17+ but `int(12)` in mysql:5.7
     7  # so ignore sharding table check, seems has no effect on sync-diff-inspector
     8  # see https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-19.html
     9  ignore-checking-items: ["schema_of_shard_tables","auto_increment_ID"] # tables generated by go-sqlsmith may have auto increment ID
    10  
    11  target-database:
    12    host: "tidb-0.tidb"
    13    port: 4000
    14    user: "root"
    15    password: ""
    16  
    17  mysql-instances:
    18    -
    19      source-id: "replica-01"
    20      black-white-list:  "instance"
    21      mydumper-thread: 4
    22      loader-thread: 16
    23      syncer-config-name: "global"
    24    -
    25      source-id: "replica-02"
    26      black-white-list:  "instance"
    27      mydumper-thread: 4
    28      loader-thread: 16
    29      syncer-config-name: "global"
    30    -
    31      source-id: "replica-03"
    32      black-white-list:  "instance"
    33      mydumper-thread: 4
    34      loader-thread: 16
    35      syncer-config-name: "global"
    36  
    37  black-white-list:
    38    instance:
    39      do-dbs: ["db_pessimistic"]
    40  
    41  syncers:
    42    global:
    43      compact: true
    44      multiple-rows: true