Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud

Aravindan, Arunjith, Ayyalusamy, Jeyaram

  • 出版商: O'Reilly|英文2書85折
  • 出版日期: 2024-08-06
  • 定價: $2,700
  • 售價: 9.5$2,565
  • 貴賓價: 9.0$2,430
  • 語言: 英文
  • 頁數: 606
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1098155890
  • ISBN-13: 9781098155896
  • 相關分類: MySQLSQL
  • 立即出貨 (庫存 < 3)

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

相關主題

商品描述

Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations, high availability, scaling techniques, and performance tuning.

Using practical techniques, tips, and real-world examples, authors Arunjith Aravindan and Jeyaram Ayyalusamy show you how to deploy and manage MySQL, Amazon RDS, Amazon Aurora, and Azure MySQL. By the end of the book, you'll have the knowledge and skills necessary to administer, manage, and optimize MySQL databases effectively.

You'll learn how to:

  • Design and implement a scalable and reliable database infrastructure using MySQL 8.0 on premises and cloud
  • Install and configure software, manage user accounts, and optimize database performance
  • Use backup and recovery strategies, security measures, and high availability solutions
  • Apply best practices for database schema design, indexing strategies, and replication techniques
  • Implement advanced database features and techniques such as replication, clustering, load balancing, and high availability
  • Troubleshoot common issues and errors, using diagnostic tools and techniques to identify and resolve problems quickly and efficiently
  • Facilitate major MySQL upgrades such as MySQL 5.7 to MySQL 8

商品描述(中文翻譯)

針對中級至高級的資料庫管理員(DBA)和IT專業人員,這本指南提供了如何管理和優化MySQL資料庫的全面概述。您將學習如何創建資料庫並實施備份和恢復、安全配置、高可用性、擴展技術和性能調優。

透過實用的技術、提示和真實案例,作者Arunjith Aravindan和Jeyaram Ayyalusamy將向您展示如何部署和管理MySQL、Amazon RDS、Amazon Aurora和Azure MySQL。到書籍結束時,您將擁有有效管理、維護和優化MySQL資料庫所需的知識和技能。

您將學習如何:
- 設計和實施可擴展且可靠的資料庫基礎架構,使用MySQL 8.0在本地和雲端
- 安裝和配置軟體,管理用戶帳戶,並優化資料庫性能
- 使用備份和恢復策略、安全措施和高可用性解決方案
- 應用資料庫架構設計、索引策略和複製技術的最佳實踐
- 實施高級資料庫功能和技術,如複製、集群、負載平衡和高可用性
- 排除常見問題和錯誤,使用診斷工具和技術快速有效地識別和解決問題
- 促進主要的MySQL升級,例如從MySQL 5.7升級到MySQL 8