The replicate filter enables
explicit inclusion or exclusion of tables and schemas. Each specification
supports wildcards and multiple entries.
| Pre-configured filter name |
replicate
| ||
| Classname |
com.continuent.tungsten.replicator.filter.ReplicateFilter
| ||
| Property prefix |
replicator.filter.replicate
| ||
| Stage compatibility | Any | ||
| tpm Option compatibility | |||
| Data compatibility | Any event | ||
| Parameters | |||
| Parameter | Type | Default | Description |
ignore
| string | empty | Comma separated list of database/tables to ignore during replication |
do
| string | empty | Comma separated list of database/tables to replicate |
Rules using the supplied parameters are evaluated as follows:
When both do and
ignore are empty, updates are
allowed to any table.
When only do is specified, only
the schemas (or schemas and tables) mentioned in the list are
replicated.
When only ignore is specified,
all schemas/tables are replicated except those defined.
For each parameter, a comma-separated list of schema or schema and table
definitions are supported, and wildcards using
* (any number of characters) and
? (single character) are also
honored. For example:
do=sales
Replicates only the schema
sales.
ignore=sales
Replicates everything, ignoring the schema
sales.
ignore=sales.*
Replicates everything, ignoring the schema
sales.
ignore=sales.quarter?
Replicates everything, ignoring all tables within the
sales schema starting with
sales.quarter and a single
character. This would ignore
sales.quarter1 but replicate
sales.quarterlytotals.
ignore=sales.quarter*
Replicates everything, ignoring all tables in the schema
sales starting with
quarter.
do=*.quarter
Replicates only the table named
quarter within any schema.
do=sales.*totals,invoices
Replicates only tables in the
sales schema that end with
totals, and the entire
invoices schema.