Error Code: 1200. The server is not configured as slave; fix in config file

设置下 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'