Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database
暫譯: 進階 MySQL 8:發掘 MySQL 的全部潛力並確保資料庫的高效能

Eric Vanier, Birju Shah, Tejaswi Malepati

  • 出版商: Packt Publishing
  • 出版日期: 2018-10-31
  • 售價: $1,560
  • 貴賓價: 9.5$1,482
  • 語言: 英文
  • 頁數: 286
  • 裝訂: Paperback
  • ISBN: 1788834445
  • ISBN-13: 9781788834445
  • 相關分類: MySQLSQL資料庫
  • 立即出貨 (庫存=1)

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

相關主題

商品描述

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL

Key Features

  • Explore the new and advanced features of MySQL 8.0
  • Use advanced techniques to optimize MySQL performance
  • Create MySQL-based applications for your enterprise with the help of practical examples

Book Description

Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.

By the end of this book, you'll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.

What you will learn

  • Explore new and exciting features of MySQL 8.0
  • Analyze and optimize large MySQL queries
  • Understand MySQL Server 8.0 settings
  • Master the deployment of Group Replication and use it in an InnoDB cluster
  • Monitor large distributed databases
  • Discover different types of backups and recovery methods for your databases
  • Explore tips to help your critical data reach its full potential

Who this book is for

Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.

Table of Contents

  1. Introduction and Topics
  2. MySQL 8 - New Features
  3. Indexing Your Data For High Performance
  4. Advanced Data Techniques For Large Queries
  5. MySQL data dictionary in MySQL 8.0
  6. MySQL Server Settings
  7. Group Replication in MySQL 8.0
  8. InnoDB Cluster in MySQL 8.0
  9. Monitoring Your Large Distributed Databases
  10. Authentication and Security Management with MySQL 8.0
  11. Advanced MySQL 8.0 Performance Tips & Techniques

商品描述(中文翻譯)

**設計具成本效益的資料庫解決方案,擴展企業運營並降低業務開銷,使用 MySQL**

#### 主要特點
- 探索 MySQL 8.0 的新功能和進階特性
- 使用進階技術來優化 MySQL 性能
- 利用實用範例為您的企業創建基於 MySQL 的應用程式

#### 書籍描述
《進階 MySQL 8》教您如何增強現有的資料庫基礎設施,並構建各種工具以改善企業應用程式和整體網站性能。本書從 MySQL 8.0 的新功能和如何利用這些功能以達到最佳效率開始。隨著您逐章學習,您將學會使用索引和進階資料查詢技術來優化 MySQL 性能,特別是針對大型查詢。您還將發現 MySQL Server 8.0 的設定,並使用 MySQL 資料字典來提升資料庫的性能。在結尾章節中,您將學習 MySQL 8.0 的群組複製技術,這將使您能夠創建彈性、高可用性和容錯的複製拓撲。您還將探索資料庫的備份和恢復技術,並了解幫助您的關鍵資料發揮其最大潛力的重要提示和技巧。

在本書結束時,您將了解 MySQL 8.0 的新安全功能,這些功能使資料庫管理員 (DBA) 能夠簡化用戶管理並提高其多用戶環境的安全性。

#### 您將學到的內容
- 探索 MySQL 8.0 的新功能和令人興奮的特性
- 分析和優化大型 MySQL 查詢
- 理解 MySQL Server 8.0 的設定
- 精通群組複製的部署並在 InnoDB 集群中使用它
- 監控大型分散式資料庫
- 發現不同類型的備份和恢復方法
- 探索幫助您的關鍵資料發揮其最大潛力的技巧

#### 本書適合誰
《進階 MySQL 8》適合希望深入了解在 MySQL 環境中構建進階資料庫應用程式的資料庫管理員、資料架構師和資料庫開發人員。

#### 目錄
1. 介紹與主題
2. MySQL 8 - 新功能
3. 為高性能索引您的資料
4. 大型查詢的進階資料技術
5. MySQL 8.0 中的 MySQL 資料字典
6. MySQL Server 設定
7. MySQL 8.0 中的群組複製
8. MySQL 8.0 中的 InnoDB 集群
9. 監控您的大型分散式資料庫
10. 使用 MySQL 8.0 的身份驗證和安全管理
11. 進階 MySQL 8.0 性能提示與技術