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]