Shulou(Shulou.com)06/01 Report--

-- replicate-wild-do-table=db_name.tbl_name

Command-Line Format--replicate-wild-do-table=namePermitted ValuesTypestring

Creates a replication filter by telling the slave thread to restrict replication to statements where any of the updated tables match the specified database and table name patterns. Patterns can contain the "%" and "_" wildcard characters, which have the same meaning as for the LIKE pattern-matching operator. To specify more than one table, use this option multiple times, once for each table. This works for cross-database updates.

Constrains any statements related to updated tables that match the specified database and table names by telling the thread to create a replication filter. Patterns can contain "%" and "_" wildcards, which are similar to pattern matching algorithms. To specify multiple tables, use this option multiple times, once for each table. This is the job of updating across databases.

It is important to cross the database, unlike replicate-do-db, where other library operations do not synchronize the set libraries. This parameter is synchronized whenever the table is involved.

-- replicate-wild-ignore-table=db_name.tbl_name

Command-Line Format--replicate-wild-ignore-table=namePermitted ValuesTypestring

Creates a replication filter which keeps the slave thread from replicating a statement in which any table matches the given wildcard pattern. To specify more than one table to ignore, use this option multiple times, once for each table. This works for cross-database updates.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.