MySQL Replication Exclude Table employs replication filters to prevent a table or database from being replicated.

Bobcares responds to all inquiries, large or small, as part of our MySQL support service.

Let’s take a closer look at how to use replication filters to ignore a table or database during replication.

MySQL Replication Exclude Table

MySQL has replication filters that explicitly allow or disallow replication of a database or a table. In this case, we’ll need to use the ignore filters. So, to ignore one or more tables, we can use one of three replication filters:

1. replicate-ignore-db
2. replicate-ignore-table
3. replicate-wild-ignore-table

Below, we’ll go through each of these options in more detail. All of them have one thing in common: they all take exactly one argument, but we can specify the same option as many times as we need. Moreover, if we use a combination of replication filters, we must study the evaluation rules.

replicate-ignore-db

Replica-ignore-db ignores statements with the default database as the ignored database in statements-based replication. Thus, Row-based replication ignores all of the tables in the specified database.

replicate-ignore-table

Basically, this option ignores the specified table.

replicate-wild-ignore-table

This is the most adaptable choice. Applies the expression to all the matching tables. For example:

• replicate-wild-ignore-table = bobcares.% : Ignores all tables in the bobcares database.
• replicate-wild-ignore-table = bobcares.b% : Ignores all b-prefixed tables in the bobcares database
• replicate-wild-ignore-table = bobcares%.bar% : Updates that use a table with a database name that begins with bobcares and a table name that begins with bar are not replicated.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To sum up, our Support team shows how to ignore a table or database during replication using replication filters.