Evaluating MySQL Parallel Replication Part 3: Benchmarks in Production

Parallel replication is a much-expected feature of MySQL. It is available in MariaDB 10.0 and in MySQL 5.7. In this 3rd post of the series, we present benchmark results from Booking.com production environments.

Photo by Master Wen on Unsplash

The Test: Catching Up with 24 Hours of Transactions

Execution Times and Speedups for Slave with Binary Logs

Discussion

Ideas and Future Work

--------Time-------->
T1: B-----------C
T2: B--C
T3: B--C
T4: B--C
T5: B--C
T6: B--C
----------------Time---------------->
T1: B-----------C
T2: B--C
T3: B--C
T4: B--C
T5: B--C
T6: B--C
1 2 3
123456789012345678901234567890123
---------Time-------->
T1: B-----------C
T2: B-- . . . . C
T3: B-- . . . . C
T4: B-- . . . . C
T5: B--C
T6: B--C
1
12345678901234567

Conclusion

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store