设置下 server_id
set global server_id = 20
再配置
CHANGE MASTER TO
MASTER_HOST = 'master',
MASTER_USER = 'XXX',
MASTER_PASSWORD = 'XXXX',
MASTER_PORT = 3306,
MASTER_LOG_FILE =' mysql-bin.005999',
MASTER_LOG_POS =0;
set global replicate_do_db = 'xxxxx';
set global replicate_ignore_db ='mysql,information_schema,performance_schema';
start slave;
show slave status;
show variables like '%Replicate%';
跳过某些错误(配置文件、需要重启):
slave_skip_errors='1062,1032'