MySQL filtering rules-misunderstanding processing

Case: Slave enabled replication filter-replicate-do-db=db1 (row copy mode), specific filtering considerations can refer to my previous Blogmysql replication filtering considerations, execute ALTER TABLE DB1.TB1 add on Master Xxx,slave related TB1 table does not take effect;

Slave copy Normal, errorlog not what information, I remember DML (insert,delete,update) operation use Otherdb;insert db1.tb1 values (); Is can be copied to slave, re-turned the next 5.5 of the document, no new notes, read two times copy rules, resolved the next Binlog understand, below attached:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4C/C1/wKioL1RE2_7xq1BcAAH7Auhu95w499.jpg "title=" capture. JPG "alt=" Wkiol1re2_7xq1bcaah7auhu95w499.jpg "/>

Cause: For DDL operations, the statement statement is still recorded in row mode, so when I execute the alter execution, I should execute the filter rule on the left (red circle), and I think the row mode is on the right side of the filter rules, or more practice Ah!

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://weipengfei.blog.51cto.com/1511707/1566002

MySQL filtering rules-misunderstanding processing