The pit in MySQL!! (Continuous update)

MySQL sinkhole one: replication filters cause data clutter ()

MySQL version 5.6.20-log

replicate_do_db: All SQL under this DB session will be executed from the library

replicate_ignore_db: All SQL below the DB session is ignored from the library

The above two replication filters can easily cause data confusion, it is best not to use

REPLICATE_DO_DB: If SQL associated with the specified replication db is executed under another DB session, the SQL is not executed from the library

And does not cause replication to fail, resulting in inconsistent master-slave data. You can replace replicate_do_db with replicate_do_table

replicate_ignore_db: If the sql,sql associated with ignoring DB is performed under another DB session, it will still be executed from the library

And does not cause replication to fail, resulting in inconsistent master-slave data. You can replace replicate_ignore_db with replicate_ignore_table

This article is from the "SQL Server MySQL" blog, so be sure to keep this source http://dwchaoyue.blog.51cto.com/2826417/1570421

The pit in MySQL!! (Continuous update)