Contact Sales

USA: +1-866-221-0634
Canada: +1-866-221-0634

Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447

Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870
Brazil: +55 11 5189-1097

MySQL Enterprise Edition Trial - Try Now

MySQL 5.6 Replication: Enhancing Slave Performance and Consistency

Topics: Replication, Performance & Scalability

MySQL replication is the foundation for scaling out database services on commodity infrastructure. MySQL 5.6 delivers significant enhancements to the performance of slave servers in a replication cluster, while also reducing resource requirements. This presentation details the following:

Multi-Threaded Slaves, allowing updates to be applied concurrently across schemas on a slave, delivering 5x higher performance

Row Based Replication, event apply enhancements delivering 7x higher performance

Optimized Row Based Replication, only replicates those elements of the row image that have changed following INSERT, UPDATE and DELETE operations.

Collectively these new feature deliver higher replication throughput for both the master and slave(s) while binary log disk space, network resource and server memory footprint are all reduced.

You must be logged in to access this content. MySQL.com is using Oracle SSO for authentication. If you already have an Oracle Web account, click the Login link. Otherwise, you can signup for a free account by clicking the Sign Up link and following the instructions.