1.1.2. Appliers

The replicator commits transactions using block commit meaning it only commits on x transactions. This improves performance but when using a non-transactional engine it can cause the problems you have seen. By default this is set to 10 (the value is replicator.global.buffer.size). It is possible to set this to 1 which will remove the problem with MyISAM tables but it will impact the performance of the replicators

Available appliers include:

  • MongoDB

  • MySQL

  • Oracle

  • Vertica

For more information on how the replicator for heterogeneous works, see Section 4.1, “How Heterogeneous Replication Works”. For more information on the batch applier, which works with datawarehouse targets, see Section 7.2, “Batch Loading for Data Warehouses”.