Get the App
SLTechnology News&Howtos  ›  Database  › 

Solve some problems of replicate-do-db through replicate-wild-do-table

Shulou Source: shulou.com Published: 2022-06-01 16:56:46 10月01日 Update

-- 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.

Tags: Data database schema update parameter name multiple algorithm thread statement this is wildcard emphasis filter synchronization work problem Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei MariaDB Shulou Tech Info Redmi Linux