# Old Configuration.

# used for binlog replication 
server-id = 101

# which flavor mysql/mariadb
flavor = "mysql"

# meta file position
# meta = "/tmp/dm_test/dm_syncer/old_meta_file"

worker-count = 16
batch = 1000

# filter

# block allow list provides a library to filter replicate on schema/table by given rules
# support regular expression , start with '~' declare use regular expression.
# rules like replication rules in MySQL, ref document:
# https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
# https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
#[block-allow-list]
#do-dbs = ["~^b.*","s1"]
#
#ignore-dbs = ["~^b.*","s1"]
#
#[[block-allow-list.do-tables]]
#db-name = "your db"
#tbl-name = "your table"
#
#[[block-allow-list.ignore-tables]]
#db-name = "~^b.*"
#tbl-name = "~^a.*"


# filter-rules filter binlog events
#[[filter-rules]]
#schema-pattern = "shard_db_*"
#table-pattern  = "shard_table_*"
# do all dml, ignore all ddl
#events = ["all dml"]
#action = "Do"

#[[filter-rules]]
#schema-pattern = "shard_db_*"
#table-pattern  = "shard_table_*"
# ignore delete sqls and drop table ddls
#events = ["delete", "drop table"]
# regular expression, ignore drop procedure queries
# sql-pattern = ["^DROP\\s+PROCEDURE"]
#action = "Ignore"


# route table

# applied after filter
# our Selector is a two level selector (schemal level, and table level)
# [[route-rules]]
# schema-pattern = "shard_db_*"
# target-schema = "shard_db"
# [[route-rules]]
# schema-pattern = "shard_db_*"
# table-pattern = "shard_table_*"
# target-schema = "shard_db"
# target-table = "shard_table"

[from]
host = "127.0.0.1"
user = "root"
password = "123456"
port = 3307
# to: the target db
# from: the source db, not in this file, auto get it from worker's config
[to]
host = "127.0.0.1"
user = "test"
password = "123456"
port = 4000