github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/dm_syncer/conf/dm-syncer-2.toml (about)

     1  # Old Configuration.
     2  
     3  # used for binlog replication 
     4  server-id = 101
     5  
     6  # which flavor mysql/mariadb
     7  flavor = "mysql"
     8  
     9  # meta file position
    10  # meta = "/tmp/dm_test/dm_syncer/old_meta_file"
    11  
    12  worker-count = 16
    13  batch = 1000
    14  
    15  # filter
    16  
    17  # block allow list provides a library to filter replicate on schema/table by given rules
    18  # support regular expression , start with '~' declare use regular expression.
    19  # rules like replication rules in MySQL, ref document:
    20  # https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
    21  # https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
    22  #[block-allow-list]
    23  #do-dbs = ["~^b.*","s1"]
    24  #
    25  #ignore-dbs = ["~^b.*","s1"]
    26  #
    27  #[[block-allow-list.do-tables]]
    28  #db-name = "your db"
    29  #tbl-name = "your table"
    30  #
    31  #[[block-allow-list.ignore-tables]]
    32  #db-name = "~^b.*"
    33  #tbl-name = "~^a.*"
    34  
    35  
    36  # filter-rules filter binlog events
    37  #[[filter-rules]]
    38  #schema-pattern = "shard_db_*"
    39  #table-pattern  = "shard_table_*"
    40  # do all dml, ignore all ddl
    41  #events = ["all dml"]
    42  #action = "Do"
    43  
    44  #[[filter-rules]]
    45  #schema-pattern = "shard_db_*"
    46  #table-pattern  = "shard_table_*"
    47  # ignore delete sqls and drop table ddls
    48  #events = ["delete", "drop table"]
    49  # regular expression, ignore drop procedure queries
    50  # sql-pattern = ["^DROP\\s+PROCEDURE"]
    51  #action = "Ignore"
    52  
    53  
    54  # route table
    55  
    56  # applied after filter
    57  # our Selector is a two level selector (schemal level, and table level)
    58  # [[route-rules]]
    59  # schema-pattern = "shard_db_*"
    60  # target-schema = "shard_db"
    61  # [[route-rules]]
    62  # schema-pattern = "shard_db_*"
    63  # table-pattern = "shard_table_*"
    64  # target-schema = "shard_db"
    65  # target-table = "shard_table"
    66  
    67  [from]
    68  host = "127.0.0.1"
    69  user = "root"
    70  password = "123456"
    71  port = 3307
    72  # to: the target db
    73  # from: the source db, not in this file, auto get it from worker's config
    74  [to]
    75  host = "127.0.0.1"
    76  user = "test"
    77  password = "123456"
    78  port = 4000