Description of synchronization parameters for different databases and tables in MySQL master-slave Replication

Description of synchronization parameters for different databases and tables in MySQL master-slave Replication

Description of synchronization parameters for different databases and tables in MySQL master-slave Replication

In replication, the following parameters are used to reduce the binlog data volume:

Master:

-- Binlog-do-db database with binary log records (multiple databases are separated by commas)
-- Ignore databases in binlog-ignore-db binary logs (multiple databases are separated by commas)

The following are examples of how to ignore the authorization table for mysql Master/Slave:
In master:
Binlog-do-db = YYY: the database to be synchronized. If this line is not added, all data is synchronized.
Binlog-ignore-db = mysql this does not record binlog, to achieve slave database does not synchronize mysql database, to ensure their respective Permissions
Binlog-ignore-db = performance_schema
Binlog-ignore-db = information_schema

Slave end
-- Replication-do-db: Set the database to be copied (multiple databases are separated by commas)
-- Replication-ignore-db: Set the replication database to be ignored (multiple databases are separated by commas)
-- Replication-do-table: Set the table to be copied.
-- Replication-ignore-table: Set the replication table to be ignored.
-- Replication-wild-do-table has the same functions as replication-do-table, but Wildcards are allowed.
-- Replication-wild-ignore-table has the same functions as replication-ignore-table, but wildcards can be added.

This article permanently updates the link address: