Overview The Skinny
In this blog post we explore various options for performance
tuning MySQL server for better slave replication performance.
A Tungsten Cluster relies upon the Tungsten Replicator to move
events from the master node to the slaves. Once the event has
been transferred to the slave as THL on disk, the slave applier
will then attempt to write it to the database. The Replicator can
only apply events as fast as MySQL allows. If the MySQL server is
somehow slow or blocking, then the Replicator will be as well.
A properly-tuned database server in addition to infrastructure
and SysAdmin best practices will go quite a long way towards
high-performance slave apply.
The Question Recently, a customer asked us:
During one of our load tests, we had a peak of 60k writes/min,
averaging …[Read more]