Replicate Filter

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.