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
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:
For more information on how the replicator for heterogeneous works, see Section 3.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”.