Back to Resources

MySQL Technical Materials

In-depth analysis of MySQL

Theoretical Resources

Deep Dive: InnoDB Transactions and Write Paths
MariaDB Corporation, 2018 Beginner
5.0
Comprehensive analysis of InnoDB's transaction processing and write paths from client connection to physical storage.
Download PDF
Mencius: Building Efficient Replicated State Machines for WANs
Yanhua Mao, 2008 Intermediate
5.0
We present a protocol for general state machine replication - a method that provides strong consistency - that has high performance in a wide-area network. In particular, our protocol Mencius has high throughput under high client load and low latency under low client load even under changing wide-area network environment and client load.
Download PDF
KuaFu: Closing the parallelism gap in database replication
C. Hong et al., 2013 Intermediate
4.0
A practical implementation for improving parallelism in database replication systems.
Download PDF

Practical Resources

The Art of Problem-Solving in Software Engineering: How to Make MySQL Better
Bin Wang, 2023 Beginner
5.0
This book uses MySQL challenges as case studies to explore problem analysis and resolution strategies. Readers will gain a deeper appreciation for logical reasoning, data structures, algorithms, and more through practical examples and insightful discussions.
View Github
Building and deploying MySQL Raft at Meta
Anirban Rahut et al., 2023 Beginner
5.0
A case study on deploying MySQL Raft at Meta for improved distributed consensus.
View Article
Integrating the Orca Optimizer into MySQL
Marathe et al., 2022 Intermediate
4.5
Case study of integrating a modern cost-based optimizer into a production RDBMS, discussing challenges and performance results.
Download PDF
FlexiRaft: Flexible Quorums with Raft
Ritwik Yadav and Anirban Rahut, 2023 Intermediate
5.0
A study on flexible quorum systems for Raft-based distributed consensus.
Download PDF
Contention-Aware Lock Scheduling for Transactional Databases
Hao Wang et al., 2018 Advanced
4.0
Contention-aware lock scheduling for transactional databases.
Download PDF