mysql主主的坑_mysql 主从踩的一个小坑

修改了主库的某库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.%