High Performance MySQL: Proven Strategies for Operating at Scale (Paperback)

High Performance MySQL: Proven Strategies for Operating at Scale (Paperback)

作者: Botros Silvia Tinley Jeremy
出版社: O'Reilly
出版在: 2021-12-14
ISBN-13: 9781492080510
ISBN-10: 1492080519
裝訂格式: Quality Paper - also called trade paper
總頁數: 382 頁





內容描述


How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from choosing the right abstraction layer for databases to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve their 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, features, and tools, this revised edition helps you design a data platform that will scale with your business. You'll learn the latest in cloud-hosted MySQL offerings, best practices for database security, and 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


作者介紹


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.




相關書籍

MCSA SQL 2016 BI Development Exam Ref 2-pack: Exam Refs 70-767 and 70-768

作者 Jose Chinchilla Stacia Varga Raj Uchhana

2021-12-14

深入探索 .NET資料存取:ADO.NET + SqlDataSource+ LINQ

作者 MIS2000 Lab. 周棟祥博士 吳進魯

2021-12-14

Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud

作者 Mauri Davide Coriani Silvano Hoffman Anna

2021-12-14