High Performance MySQL
Bin Wang, 2012
Beginner
5.0
With High Performance MySQL, you will learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Download From Github
The Art of Problem-Solving in Software Engineering: How to Make MySQL Better
Bin Wang, 2024
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
SQL Injection Attacks and Defense
Justin Clarke et al., 2009
Beginner
5.0
SQL injection is one of the most devastating vulnerabilities to impact a business, as it can lead to exposure of all of the sensitive information stored in an application's database.
Download PDF
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