MySQL: a checklist for the high-load newcomer

on YouTube ↗01h 00m

" summary

Overview of MySQL variants (Oracle MySQL, Percona Server, MariaDB) and common MySQL questions for high-load projects, with concrete guidance on choosing optimal configuration parameter values. The talk uses a dialogue format to cover capabilities of each server variant and tuning decisions to handle project growth.

AI-written summary · about

" chapters (25)

1. 0:00Introduction
2. 2:51Highload in numbers
3. 7:04Highload definition
4. 8:10MySQL forks overview
5. 13:26Open source MySQL
6. 14:31Memory and buffer optimization
7. 18:24Reliability vs performance
8. 19:30MySQL caching
9. 23:12MySQL replication basics
10. 28:49Galera Cluster
11. 32:46MySQL sharding tools
12. 33:48MySQL indexes
13. 36:19Full-text indexes alternatives
14. 37:00Slow query optimization
15. 39:34MySQL tuning under load
16. 44:10Hardware and storage
17. 47:00Backup recommendations
18. 48:03MySQL and virtualization
19. 49:57NUMA and MySQL
20. 50:18GTID replication pros/cons
21. 54:13Galera Cluster issues
22. 56:02Regional sharding
23. 57:54Load balancing and proxy
24. 58:59Dedicated vs shared infra
25. 59:42Summary

" related talks

• 44mMySQL vs something else Evaluating alternative databasesMark Callaghan · HighLoad++ 2013
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019
• 49mHighLoad Solutions On MySQLXiaobin Lin · HighLoad++ 2015
• 44mChallenges of Using MySQL Efficiently on Modern HardwareAleksey Kopytov · HighLoad++ 2014
• 44mMySQL vs something else Evaluating alternative databasesMark Callaghan · HighLoad++ 2013
• 44mChallenges of Efficiently Using MySQL on Modern HardwareAleksey Kopytov · HighLoad++ 2014
• 54mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013