The Question Recently, a customer asked us:
Why would Tungsten Replicator be slow to apply to MySQL?
The Answer Performance Tuning 101
When you run
trepctl status and see:
appliedLatency : 7332.394
like this on a slave, it is almost always due to the inability for the target database to keep up with the applier.
This means that we often need to look first to the database layer for the solution.
Here are some of the things to think about when dealing with this issue:
Architecture and Environment
√ Are you on bare metal?
√ Using the cloud?
√ Dev or Prod?
√ Network speed and latency?
√ Distance the data needs to travel?
√ Network round trip times? Is the …