Chapter 10. Replication Filters

Table of Contents

10.1. Enabling/Disabling Filters
10.2. Enabling Additional Filters
10.3. Filter Status
10.4. Filter Reference
10.4.1. ansiquotes.js Filter
10.4.2. BidiRemoteSlave (BidiSlave) Filter
10.4.3. breadcrumbs.js Filter
10.4.4. BuildAuditTable Filter
10.4.5. BuildIndexTable Filter
10.4.6. CaseMapping (CaseTransform) Filter
10.4.7. CDCMetadata (CustomCDC) Filter
10.4.8. ColumnName Filter
10.4.9. ConsistencyCheck Filter
10.4.10. ConvertStringFromMySQL Filter
10.4.11. DatabaseTransform (dbtransform) Filter
10.4.12. dbrename.js Filter
10.4.13. dbselector.js Filter
10.4.14. dbupper.js Filter
10.4.15. dropcolumn.js Filter
10.4.16. dropcomments.js Filter
10.4.17. dropmetadata.js Filter
10.4.18. dropstatementdata.js Filter
10.4.19. Dummy Filter
10.4.20. EnumToString Filter
10.4.21. EventMetadata Filter
10.4.22. foreignkeychecks.js Filter
10.4.23. Heartbeat Filter
10.4.24. insertsonly.js Filter
10.4.25. Logging Filter
10.4.26. MySQLSessionSupport (mysqlsessions) Filter
10.4.27. NetworkClient Filter
10.4.28. nocreatedbifnotexists.js Filter
10.4.29. OptimizeUpdates Filter
10.4.30. PrimaryKey Filter
10.4.31. PrintEvent Filter
10.4.32. Rename Filter
10.4.33. ReplicateColumns Filter
10.4.34. Replicate Filter
10.4.35. SetToString Filter
10.4.36. Shard Filter
10.4.37. shardbyseqno.js Filter
10.4.38. shardbytable.js Filter
10.4.39. SkipEventByType Filter
10.4.40. TimeDelay (delay) Filter
10.4.41. tosingledb.js Filter
10.4.42. truncatetext.js Filter
10.4.43. zerodate2null.js Filter
10.5. JavaScript Filters
10.5.1. Writing JavaScript Filters

Filtering operates by applying the filter within one, or more, of the stages configured within the replicator. Stages are the individual steps that occur within a pipeline, that take information from a source (such as MySQL binary log) and write that information to an internal queue, the transaction history log, or apply it to a database. Where the filters are applied ultimately affect how the information is stores, used, or represented to the next stage or pipeline in the system.

For example, a filter that removed out all the tables from a specific database would have different effects depending on the stage it was applied. If the filter was applied on the master before writing the information into the THL, then no slave could ever access the table data, because the information would never be stored into the THL to be transferred to the slaves. However, if the filter was applied on the slave, then some slaves could replicate the table and database information, while other slaves could choose to ignore them. The filtering process also has an impact on other elements of the system. For example, filtering on the master may reduce network overhead, albeit at a reduction in the flexibility of the data transferred.

In a standard replicator configuration with MySQL, the following stages are configured in the master, as shown in Figure 10.1, “Filters: Pipeline Stages on Masters”.

Figure 10.1. Filters: Pipeline Stages on Masters

Filters: Pipeline Stages on Masters

Where:

  • binlog-to-q Stage

    The binlog-to-q stage reads information from the MySQL binary log and stores the information within an in-memory queue.

  • q-to-thl Stage

    The in-memory queue is written out to the THL file on disk.

Within the slave, the stages configured by default are shown in Figure 10.2, “Filters: Pipeline Stages on Slaves”.

Figure 10.2. Filters: Pipeline Stages on Slaves

Filters: Pipeline Stages on Slaves

  • remote-to-thl Stage

    Remote THL information is read from a master datasource and written to a local file on disk.

  • thl-to-q Stage

    The THL information is read from the file on disk and stored in an in-memory queue.

  • q-to-dbms Stage

    The data from the in-memory queue is written to the target database.

Filters can be applied during any configured stage, and where the filter is applied alters the content and availability of the information. The staging and filtering mechanism can also be used to apply multiple filters to the data, altering content when it is read and when it is applied.

Where more than one filter is configured for a pipeline, each filter is executed in the order it appears in the configuration. For example, within the following fragment:

...
replicator.stage.binlog-to-q.filters=settostring,enumtostring,pkey,colnames
...

settostring is executed first, followed by enumtostring, pkey and colnames.

For certain filter combinations this order can be significant. Some filters rely on the information provided by earlier filters.