High Performance MySQL: Proven Strategies for Running MySQL at Scale

Silvia Botros

ISBN 10: 1492080519 / ISBN 13: 9781492080510

Edité par O'Reilly Media, United States, Sebastopol, 2021

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. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. N° de réf. du vendeur GOR014245768

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

À propos des auteurs: Silvia Botros is a Senior Principal Engineer at Twilio. During her time at SendGrid, she helped deploy and maintain various MySQL datastores that support the mail pipeline and other products that SendGrid offers and to drive MySQL designs from inception to production.

Jeremy Tinley is a Senior Staff Engineer at Etsy, with over 20 years of MySQL experience. Throughout his career, he has managed tens of thousands of MySQL instances with an eye towards availability, reliability, and operational efficiency.

Détails bibliographiques

Titre : High Performance MySQL: Proven Strategies ...
Éditeur : O'Reilly Media, United States, Sebastopol
Date d'édition : 2021
Reliure : Paperback
Etat : Very Good
Edition : 4ème Édition