set global server_id = 2;
show slave status; //查看binlog日志信息
stop slave;
change replication filter
replicate_do_db=(bypass);
change master to
master_host = '192.168.0.1',
master_port = 3306,
master_user='root',
master_password='root',
master_log_file='binlog.000090',
master_log_pos=2013437;
start slave;
show master status;
//主从同步失败
stop slave;
set global sql_slave_skip_counter=2;
show slave status;