Within certain replication deployments, enforcing that only row-based information is replicated is important to ensure that the row data is replicated properly. For example, when replicating to databases that do not accept statements, these events must be filtered out.
| Pre-configured filter name |
dropstatementdata
| ||
| JavaScript Filter File |
tungsten-replicator/support/filters-javascript/dropstatementdata.js
| ||
| Property prefix |
replicator.filter.dropstatementdata
| ||
| Stage compatibility |
binlog-to-q,
q-to-dbms
| ||
| tpm Option compatibility |
--svc-extractor-filters,
--svc-applier-filters
| ||
| Data compatibility | Any event | ||
| Parameters | |||
| Parameter | Type | Default | Description |
This is achieved by checking for statements, and then removing them from the event:
data = event.getData();
for(i = 0; i < data.size(); i++)
{
d = data.get(i);
if(d instanceof com.continuent.tungsten.replicator.dbms.StatementData)
{
data.remove(i);
i--;
}
}