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 …[Read more...]