High Performance MySQL Strategies for Scaling by Silvia Botros Jeremy Tinley 2021 Paperback

$ 16.57

Type: Textbook Subject Area: Mathematics, Computers ISBN-10: 1492080519 Publication Year: 2021 Dewey Edition: 23 Dewey Decimal: 005.75/6 Subject: Programming / Open Source, General, Programming Languages / Sql, Databases / Data Warehousing Number of Pages: 375 Pages Format: Trade Paperback Edition Number: 4 brand: O'reilly Media, Incorporated Intended Audience: Scholarly & Professional Publication Name: High Performance Mysql : Proven Strategies for Operating at Scale Item Width: 7 in Item Height: 0.9 in Synopsis: 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 Item Length: 9.2 in Illustrated: Yes Author: Silvia Botros, Jeremy Tinley LCCN: 2022-439530 Item Weight: 23.6 Oz LC Classification Number: QA76.73.S67 ISBN-13: 9781492080510 gtin13: 9781492080510 Language: English Publisher: O'reilly Media, Incorporated

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

  1. High Performance MySQL is a must-read for anyone serious about optimizing databases. Packed with practical strategies, it dives deep into query tuning, schema design, and scaling techniques. The clear explanations and real-world examples make complex concepts easy to grasp. Whether you're troubleshooting slow queries or setting up high-availability systems, this book delivers actionable insights. The updated content covers modern MySQL practices, making it an invaluable resource for DBAs and developers working at scale. Highly recommended for leveling up your MySQL performance game!

    Sylvia P.e62