MySQL 9 Cookbook, Second Edition
Practical recipes for installing, securing, optimizing, and scaling MySQL 9 in production
This book is all about having a deep understanding of every configuration decision, every index design, every backup policy, and every failover drill. All the recipes in this book are for real-life tasks that you'd actually do, with all the exact commands and configurations that work on a production linux server running MySQL.
About
About the Book
This book is the perfect hands-on reference for any database administrator, backend developer or data engineer working with MySQL in production. It's organised into 75+ practical, task-driven recipes solving the real challenges that practitioners face every day. These include things like installing and hardening a MySQL 9 server, migrating from MySQL 5.7, MongoDB and PostgreSQL, diagnosing deadlocks and startup failures, tuning slow queries with EXPLAIN ANALYZE, configuring InnoDB Cluster for automatic failover, and implementing point-in-time recovery with the binary log and Clone Plugin.
This second edition looks at the most significant new features of MySQL 9, including the VECTOR data type for use with AI and machine learning workloads, the JavaScript Multilingual Engine powered by GraalVM, the updated InnoDB ClusterSet for high availability across multiple data centres, and the structured JSON error log. Every recipe is shown on a consistent, production-realistic sample platform, giving readers the context to apply each technique directly to their own environments. So, whatever you're doing, this cookbook's got you covered. It'll give you all the exact steps, commands, and explanations you need to get the job done.
Key Learnings
- Install, configure, and secure a production-ready MySQL 9 server on Linux.
- Migrate databases from MySQL 5.7, MongoDB, and PostgreSQL to MySQL 9.
- Tune InnoDB buffer pools, composite indexes, and slow queries for peak throughput.
- Configure GTID-based source-replica replication with automated health monitoring scripts.
- Build fault-tolerant InnoDB Clusters with automatic failover using MySQL Shell AdminAPI.
- Recover databases to a precise point in time using binary logs and mysqlbinlog.
- Secure MySQL 9 with AppArmor, transparent encryption, SSH tunneling, and RBAC roles.
- Store and search AI embedding vectors using MySQL 9's native VECTOR data type.
- Write JavaScript stored procedures using the MySQL Multilingual Engine and GraalVM.
- Diagnose deadlocks, table corruption, and startup failures with structured JSON logs.
Table of Content
- Installing and Configuring Database Server
- Migrating to New Server
- Managing MySQL Architecture and Storage Engines
- Securing Database Server
- Optimizing Queries and Performance
- MySQL Replication
- MySQL High Availability
- Backup, Recovery, and Maintenance
- Advanced Troubleshooting and Debugging
- Advanced Data Features
- JavaScript Stored Programs with MySQL MLE
Feedback
Previous Editions
Packages
Pick Your Package
All packages include the ebook in the following formats: PDF
The Book
Minimum price
Suggested price$29.99$29.99
This book + Extras Downloadable (MySQL 9 QuickStart Pro)
Minimum price
Suggested price$56.99$49.99
- MySQL 9 QuickStart ProAdministrative strategies to upgrade, migrate and optimize databases with MySQL 9
This book is also available in the following packages:
This book + Extras Downloadable (MySQL 8 Cookbook)
No Description Available
- MySQL 8 CookbookReady solutions to achieve highest levels of enterprise database scalability, security, reliability, and uptime
- Minimum price
- $49.99
- Suggested price
- $56.99
- MySQL 8 Cookbook
This book + Extras Downloadable (MySQL 9 QuickStart Pro + MySQL 8 Cookbook)
No Description Available
- MySQL 9 QuickStart ProAdministrative strategies to upgrade, migrate and optimize databases with MySQL 9
- MySQL 8 CookbookReady solutions to achieve highest levels of enterprise database scalability, security, reliability, and uptime
- Minimum price
- $69.99
- Suggested price
- $76.99
- MySQL 9 QuickStart Pro
Author
About the Author
We are the engineer’s publisher, the coder’s mentor, and the content alchemist—meticulously turning dense tech into practical gold. With a growing library of 100+ titles, we don’t just develop technical books, rather we build roadmaps for professionals across Python, MySQL, DevOps, Rust, AI, Kotlin, Arduino, Golang and everything around the massive IT ecosystem. Every chapter, every script, every project is a tool in the hands of developers who want to get things done.
Where others summarize, we construct step-by-step learning blueprints, cutting through clutter, banning the fluff, and ensuring every paragraph delivers hands-on value. Our audience isn’t learning from scratch—they’re leveling up with purpose, and we stand by them with code-first content, consistent project workflows, and a zero-redundancy approach.
The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.