High Performance MySQL: Proven Strategies for Running MySQL at Scale

This guide teaches advanced techniques for optimizing MySQL performance, including service-level objectives, schemas, indexes, queries, server tuning, operating system, and hardware. It also covers 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, it helps design a relational data platform that scales with your business.

Format: Paperback / softback
Length: 375 pages
Publication date: 30 November 2021
Publisher: O'Reilly Media, Inc, USA

With High Performance MySQL, you'll delve into advanced techniques for optimizing your MySQL server, operating system, and hardware to maximize its potential. This comprehensive guide covers setting service-level objectives, designing schemas, indexes, and queries, and tuning your platform for optimal performance. It also teaches database administrators safe and practical methods to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advancements in cloud- and self-hosted MySQL, InnoDB performance, and new features and tools, this revised edition empowers you to design a scalable relational data platform that aligns with your business growth. You'll gain valuable insights into database security best practices, along with practical lessons learned in performance and database stability.

Dive into MySQL's architecture, exploring key facts about its storage engines and how server configuration interacts with your hardware and deployment choices. Understand how query performance can be integrated into your software delivery process and examine enhancements to MySQL's replication and high availability. Compare different MySQL offerings in managed cloud environments and explore MySQL's full stack optimization, from application-side configuration to server tuning.

Transform traditional database management tasks into automated processes, leveraging MySQL's powerful features and capabilities to streamline your operations and achieve exceptional performance. Whether you're a database administrator, developer, or business owner, High Performance MySQL provides the knowledge and tools you need to unlock MySQL's full power and optimize your database infrastructure.

Weight: 674g
Dimension: 178 x 234 x 28 (mm)
ISBN-13: 9781492080510
Edition number: 4 ed