Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

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的企業應用程序

書籍描述:
《Advanced 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環境中深入研究建立高級數據庫應用程序。目錄如下:
1. 簡介和主題
2. MySQL 8 - 新功能
3. 為高性能索引數據
4. 大型查詢的高級數據技術
5. MySQL 8.0中的數據字典
6. MySQL Server設置
7. MySQL 8.0中的群組複製
8. MySQL 8.0中的InnoDB集群
9. 監控大型分佈式數據庫
10. 使用MySQL 8.0進行身份驗證和安全管理
11. MySQL 8.0高級性能技巧和技術