MySQL5.7 Setting up synchronous replication filtering do not restart the MySQL service process

In the mysql5.5/5.6 version, set up synchronous replication filtering, such as setting the T2 table that ignores the test library, you need to add in the my.cnf config file:

Replicate-ignore-table=test.t2

The MySQL service process must be restarted to take effect.

In MySQL5.7, a new command is available to support online dynamic modification without restarting the MySQL process.

Example:

Change REPLICATION FILTER replicate_do_db= (DB1,DB2); Change REPLICATION FILTER replicate_ignore_db= (DB1,DB2); Change REPLICATION FILTER replicate_do_table= (DB1.T1); Change REPLICATION FILTER replicate_ignore_table= (DB2.T2); Change REPLICATION FILTER replicate_wild_do_table= (' db.t% '); Change REPLICATION FILTER replicate_wild_ignore_table= (' db%.a% '); Change REPLICATION FILTER replicate_rewrite_db= ((from_db, to_db));

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/54/0F/wKiom1R2yAfhoNrRAAPqLyQXpZM030.jpg "title=" Replication_ignore.jpg "alt=" Wkiom1r2yafhonrraapqlyqxpzm030.jpg "/>

Enhanced ease of use, a lot of convenience.

Reference:

Http://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html

This article is from the "Spring Yang Technical column" blog, please be sure to keep this source http://hcymysql.blog.51cto.com/5223301/1583247

MySQL5.7 Setting up synchronous replication filtering do not restart the MySQL service process