How we sped up MySQL Handler Socket ninefold

on YouTube ↗39m

" summary

The talk describes using MySQL HandlerSocket as a non-SQL data-access interface for the high-load Wamba.ru project because the standard SQL interface could not handle the traffic. It explains that as load grew HandlerSocket also started to fail and outlines the work done to speed up HandlerSocket performance by about 9× to avoid constant provisioning of more MySQL replicas.

AI-written summary · about

" chapters (22)

1. 0:00Introduction
2. 3:42Tarantool introduction
3. 5:27MySQL 5.7 replicator adaptation
4. 9:48HandlerSocket vs Tarantool performance
5. 11:35Why Tarantool is faster
6. 12:37Replicating only needed data
7. 15:06Tarantool deployment results
8. 16:56Post-failure recovery
9. 17:40Tarantool community and support
10. 19:50Data consistency checks
11. 21:16Tarantool drawbacks
12. 22:20Replicator license and development
13. 23:47Summary and resource savings
14. 24:11Q&A: Replicator crash
15. 26:19Q&A: App rewrite
16. 27:43Q&A: Hardware issues
17. 29:54Q&A: Checksums and IronDB
18. 30:58Q&A: MariaDB support
19. 31:39Q&A: Alternative solutions
20. 32:25Q&A: System architecture
21. 35:05Q&A: Server resources
22. 36:53Q&A: ALTERs and data structure

" related talks

• 16mHow to improve MySQL performance even with Handler Socket with replication to in-memory TarantoolAlexander Yakovlev · Percona Live Open Source Database Conference 2017
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 30mFrom 15,000 Database Connections to under 100—A Tech Debt TaleSunny Beatteay · SREcon21
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 48mMySQL Load Balancers - MaxScale, ProxySQL, HAProxy, MySQL Router & nginx - a close up lookKrzysztof Ksiazek · Percona Live Open Source Database Conference 2017
• 55mProxySQL Use Case ScenariosAlkin Tezuysal · HighLoad++ 2017
• 37mScale MySQL beyond limits with ProxySQLRatnadeep Debnath · Rootconf 2019