The objective of this benchmark is to measure the performance
improvement achieved when enabling the Multi-Threaded Slave
enhancement delivered as a part MySQL 5.6.
As the results demonstrate, Multi-Threaded Slaves delivers 5x
higher replication performance based on a configuration with 10
databases/schemas. For real-world deployments, higher replication
performance directly translates to:
· Improved consistency of reads from slaves (i.e. reduced risk of
reading "stale" data)
· Reduced risk of data loss should the master fail before
replicating all events in its binary log (binlog)
The multi-threaded slave splits processing between worker threads
based on schema, allowing updates to be applied in parallel,
rather than sequentially. This delivers benefits to those
workloads that isolate application …
[Read more]