Mysql DBA Advanced Operations Learning Note-mysql Master-slave replication specifies different library table parameter descriptions

1. Synchronizing a small number of libraries

Binlog-do-db=db_px

REPLICATE-DO-DB=DB_PX---If you need to update across databases and you do not want to replicate these and new, you should use this option

REPLICATE-DO-TABLE=DB_PX----Allow cross-database updates

REPLICATE-WILD-DO-TABLE=DB_PX---for cross-database updates

2.ignore: Exclude

Binlog-ignore-db=mysql

replicate-ignore-db=mysql-This option should be used if you want to update across databases and do not want to replicate these updates

replicate-ignore-table=mysql-This option can be updated across databases

replicate-wild-ignore-table=mysql-This option can be updated across databases

Hint: multi-Library, multi-table, multi-line write

Reference MySQL Manual

The fifth chapter: database management

Sixth: Replication in MySQL

The replication can also be used to reduce the amount of binlog data in order to achieve increased efficiency.

Master side:

--binlog-do-db Binary Logging Database (multiple databases, delimited)

--BINLOG-IGNORE-DB binary Log ignored database (multiple databases, delimited)

Slave End:

--REPLICATION-DO-DB setting the database to be replicated (multiple databases, delimited)

--REPLICATION-IGNORE-DB setting ignores replicated databases (multiple databases, delimited)

--replication-do-table setting the table to be copied (multiple tables, delimited)

--replication-ignore-table setting ignores replicated tables (multiple tables, delimited)

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

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

Mysql DBA Advanced Operations Learning Note-mysql Master-slave replication specifies different library table parameter descriptions