High Performance MySQL: Proven Strategies for Operating at Scale, 4/e (Paperback)

Botros, Silvia, Tinley, Jeremy

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

如何充分發揮MySQL的威力?透過《高性能MySQL》,您將學習到從選擇適合的資料庫抽象層到設計架構、索引和查詢,再到調整伺服器、作業系統和硬體以實現其全部潛力的高級技巧。本指南還教導資料庫管理員通過複製、負載平衡、高可用性和故障轉移等安全且實用的方式來擴展應用程式。

本修訂版根據雲端和自託管MySQL、InnoDB性能、功能和工具的最新進展進行了更新,幫助您設計一個能夠與您的業務一起擴展的數據平台。您將學習到最新的雲端MySQL解決方案、資料庫安全性的最佳實踐,以及在性能和資料庫穩定性方面的寶貴經驗。

本書內容包括:
- 深入了解MySQL的架構,包括其存儲引擎的關鍵信息
- 學習伺服器配置如何與硬體和部署選擇相結合
- 將查詢性能納入軟體交付流程
- 探索MySQL複製和高可用性的改進
- 比較不同的受管雲環境中的MySQL解決方案
- 從應用程式端配置到伺服器調優,探索MySQL的全棧優化
- 將傳統的資料庫管理任務轉化為自動化流程

作者簡介

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.

作者簡介(中文翻譯)

Silvia Botros 是 Twilio 的高級主任工程師。在 SendGrid 的時間裡,她協助部署和維護多個支援郵件流程和其他 SendGrid 產品的 MySQL 資料庫,並推動 MySQL 設計從構思到實際運作。

Jeremy Tinley 是 Etsy 的高級工程師,擁有超過 20 年的 MySQL 經驗。在他的職業生涯中,他管理了數以萬計的 MySQL 實例,並注重可用性、可靠性和運營效率。