Sitemap
Booking.com Infrastructure

Core Infrastructure in Booking.com

Evaluating MySQL Parallel Replication Part 4: More Benchmarks in Production

10 min readSep 27, 2016

--

Photo by Master Wen on Unsplash

Key Design Decision: In-Order Commit

Graph # 0: Retried Transactions on a MariaDB 10.0 Slave

The Test

Graph # 1a: E1 SB-HD — Conservative vs Aggressive Speedups
(CPU-bound workload with some cache misses)
Graph # 1b: E1 SB-ND — Conservative vs Aggressive Speedups
(CPU-bound workload with some cache misses)
Graph # 2a: E2 SB-HD — Conservative vs Aggressive Speedups
(CPU-bound workload)
Graph # 2b: E2 SB-ND — Conservative vs Aggressive Speedups
(CPU-bound workload)
Graph # 3a: E3 SB-HD — Conservative vs Aggressive Speedups
(Mixed CPU and IO workload)
Graph # 4a: E4 SB-HD — Conservative vs Aggressive Speedups
(IO-bound workload)

Discussion

Conclusion

$ for i in $(seq 4978 5003); do
mysqlbinlog $(printf "binlog.%06d" $i) |
grep -i "CREATE TABLE IF NOT EXISTS"; done | wc -l
211753

--

--

No responses yet