Book description
How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in cloud- and self-hosted MySQL, InnoDB performance, and new features and tools, this revised edition helps you design a relational data platform that will scale with your business. You'll learn best practices for database security along with hard-earned lessons in both performance and database stability.
- Dive into MySQL's architecture, including key facts about its storage engines
- Learn how server configuration works with your hardware and deployment choices
- Make query performance part of your software delivery process
- Examine enhancements to MySQL's replication and high availability
- Compare different MySQL offerings in managed cloud environments
- Explore MySQL's full stack optimization from application-side configuration to server tuning
- Turn traditional database management tasks into automated processes
Publisher resources
Table of contents
- Foreword
- Preface
- 1. MySQL Architecture
- 2. Monitoring in a Reliability Engineering World
- 3. Performance Schema
- 4. Operating System and Hardware Optimization
- 5. Optimizing Server Settings
- 6. Schema Design and Management
- 7. Indexing for High Performance
- 8. Query Performance Optimization
- 9. Replication
- 10. Backup and Recovery
- 11. Scaling MySQL
- 12. MySQL in the Cloud
- 13. Compliance with MySQL
- A. Upgrading MySQL
- B. MySQL on Kubernetes
- Index
- About the Authors
Product information
- Title: High Performance MySQL, 4th Edition
- Author(s):
- Release date: November 2021
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781492080510
You might also like
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
book
Clean Code: A Handbook of Agile Software Craftsmanship
Even bad code can function. But if code isn't clean, it can bring a development organization …
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Data Science from Scratch, 2nd Edition
To really learn data science, you should not only master the tools—data science libraries, frameworks, modules, …