MySQL Master-slave replication specifies different library table synchronization parameter descriptions

Reduce the amount of binlog data in replication with the following parameters

Master side:

--binlog-do-db Binary Logging Database (multiple databases separated by commas)

--BINLOG-IGNORE-DB database is ignored in binary log (multiple databases are separated by commas)

The following are examples of MySQL master-slave ignore authorization tables:

In master:

BINLOG-DO-DB=YYY the database that needs to be synchronized. Not adding this line means synchronizing all

Binlog-ignore-db = MySQL This is not logged binlog to reach the MySQL library from the library out of sync to ensure the respective permissions

Binlog-ignore-db = Performance_schema

Binlog-ignore-db = Information_schema

Slave end

--REPLICATION-DO-DB setting the database to be replicated (multiple databases are separated by commas)

--REPLICATION-IGNORE-DB Setting the replication database that needs to be ignored (multiple databases are separated by commas)

--replication-do-table setting the table to be copied

--replication-ignore-table Setting the replication table that needs to be ignored

--replication-wild-do-table is the same as the replication-do-table function, but can be a wildcard

--replication-wild-ignore-table is the same as the replication-ignore-table function, but it can be added with wildcard characters

This article is from the "Crazy_sir" blog, make sure to keep this source http://douya.blog.51cto.com/6173221/1795342

MySQL Master-slave replication specifies different library table synchronization parameter descriptions