Do the database and table names need to be the same for drainer to synchronize upstream and downstream databases?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: drainer同步上下游数据库库名及表名必须相同吗?

| username: kuweilong666

Does the database name and table name for the drainer synchronization between the upstream and downstream databases need to be the same?

| username: WalterWj | Original post link

I remember there seems to be a route configuration :thinking:

| username: tidb菜鸟一只 | Original post link

It should be the same. Just think of it as MySQL master-slave replication.

| username: zhanggame1 | Original post link

Based on binlog, the table names must be the same.

| username: kuweilong666 | Original post link

Is it possible to synchronize table1 from the source database db1 to table1 in the target database db2? The database names are different, but the table names are the same.

| username: kuweilong666 | Original post link

Can the upstream and downstream database names and table names be different?

| username: lichunzhu-PingCAP | Original post link

The names of upstream and downstream tables need to be consistent; they cannot be different.

| username: weixiaobing | Original post link

According to the official documentation, drainer does not have the remap function and can only be consistent upstream and downstream.

| username: WalterWj | Original post link

I guess I remembered it wrong…