The BidiRemoteSlaveFilter is used by Tungsten Replicator to prevent statements that originated from this service (i.e. where data was extracted), being re-applied to the database. This is a requirement for replication to prevent data that may be transferred between hosts being re-applied, particularly in multi-master and other bi-directional replication deployments.
|Pre-configured filter name||
|tpm Option compatibility|
|Data compatibility||Any event|
||Local service name of the service that reads the binary log|
||If true, allows statements that may be unsafe for bi-directional replication|
||If true, allows statements from any remote service, not just the current service|
The filter works by comparing the server ID of the THL event that was created when the data was extracted against the server ID of the current server.
When deploying through the tpm service the filter is
automatically enabled for remote slaves. For complex deployments,
particularly those with bi-directional replication (including
allowBidiUnsafe parameter may
need to be enabled to allow certain statements to be re-executed.