mysql 多源复制 ，多库多表合到一个库

Question

mysql 多源复制 ，多库多表合到一个库，库名无法重新修改，配置文件如下：
【slave】

[mysqld]
user=mysql
character-set-server=utf8mb4
default_authentication_plugin=mysql_native_password

server_id=1006

replicate-ignore-db = mysql
replicate-ignore-db = information_schema
replicate-ignore-db = performance_schema
replicate-ignore-db = sys

#read_only=1

replicate-do-db=mass

replicate-rewrite-db=zdbtest->mass

relay-log =mysqld-relay-bin
log-slave-updates = ON

slave-parallel-type=LOGICAL_CLOCK

relay_log_recovery=ON

slave_net_timeout = 30
slave_parallel_workers = 16

#slave-skip-errors = all
#slave-skip-errors = 1062,1053,1146,1213,1264,1205,1396


sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES


master_info_repository=TABLE
relay_log_info_repository=TABLE

gtid-mode=on
enforce-gtid-consistency=true

plugin-load=rpl_semi_sync_slave=semisync_slave.so
rpl_semi_sync_slave_enabled=1

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

[master]

[mysqld]
user=mysql
character-set-server=utf8mb4
default_authentication_plugin=mysql_native_password

server-id=1003

log-bin=mysql-bin

binlog-format=MIXED

binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=sys

sync_binlog=1
auto_increment_increment=2
auto_increment_offset=1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

gtid-mode=on
enforce-gtid-consistency=true

master_info_repository=TABLE
relay_log_info_repository=TABLE

plugin-load=rpl_semi_sync_master=semisync_master.so
rpl_semi_sync_master_enabled=1


##
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

帮忙看看有什么问题没有？？？

Answer 1

根据你提供的配置文件来看，我认为这里可能存在一个问题，就是在slave端的配置文件中，replicate-do-db值的设置为mass，但是在另一行中又有replicate-rewrite-db=zdbtest->mass的设置，这两个设置可能会相互冲突。我的建议是尝试删除replicate-rewrite-db=zdbtest->mass这一行并重新启动mysql服务，看看是否能够正常工作。