修改了主库的某库dbname2的event scheduler,从库上并没有这个库,
之后从库上 show slave status\G 发现报错
Error 'Unknown database 'dbname2'' on query. Default database: 'dbname2'.
Query: 'ALTER DEFINER=`root`@`%` EVENT `productGeneralizeTimerJob` ON SCHEDULE EVERY 1 DAY STARTS '2016-03-27 00:01:00' ON COMPLETION PRESERVE DISABLE DO BEGIN

查看主库相关binglog
use `dbname2`/*!*/;
SET TIMESTAMP=1466156563/*!*/;
alter event `productGeneralizeTimerJob` disable

结论:

使用replicate_wild_do_table按表过滤,

event并不属于表,所以不会被复制过来


主库binlog-do-db不做过滤
从库配置replicate_wild_do_table=dbname.%