MySQL 8 Administrator's Guide: Effective guide to administering high-performance MySQL 8 solutions

Chintan Mehta, Ankit Bhavsar, Hetal Oza, Subhash Shah

  • 出版商: Packt Publishing
  • 出版日期: 2018-02-15
  • 售價: $1,380
  • 貴賓價: 9.5$1,311
  • 語言: 英文
  • 頁數: 510
  • 裝訂: Paperback
  • ISBN: 1788395190
  • ISBN-13: 9781788395199
  • 相關分類: MySQLSQL
  • 立即出貨 (庫存=1)

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

商品描述

Step by step guide to monitor, manage, and secure your database engine

Key Features

  • Your companion to master all the administration-related tasks in MySQL 8
  • Ensure high performance and high availability of your MySQL solution using effective replication and backup techniques
  • A comprehensive guide to performing query optimization, security and a whole host of other administrative tasks in MySQL 8

Book Description

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This handbook will be your companion to understand the newly introduced features in MySQL and how you can leverage them to design a high-performance MySQL solution for your organization.

This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial administration topics that you will find useful in your day to day work. Topics such as migrating to MySQL 8, MySQL benchmarking, achieving high performance by implementing the indexing techniques, and optimizing your queries are covered in this book. You will also learn how to perform replication, scale your MySQL solution and implement effective security techniques. A special section on the common and not so common troubleshooting techniques for effective MySQL administration is also covered in this book.

By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

What you will learn

  • Understanding different MySQL 8 data types based on type of contents and storage requirements
  • Best practices for optimal use of features in MySQL 8
  • Explore globalization configuration and caching techniques to improve performance
  • Create custom storage engine as per system requirements
  • Learn various ways of index implementation for flash memory storages
  • Configure and implement replication along with approaches to use replication as solution
  • Understand how to make your MySQL 8 solution highly available
  • Troubleshoot common issues and identify error codes while using MySQL 8

Who This Book Is For

This book is intended for MySQL administrators who are looking for a handy guide covering all the MySQL administration-related tasks. If you are a DBA looking to get started with MySQL administration, this book will also help you. Knowledge of the basic database concepts is required to get started with this book.

商品描述(中文翻譯)

逐步指南:監控、管理和保護您的資料庫引擎

主要特點:

- 成為掌握 MySQL 8 所有管理相關任務的指南
- 使用有效的複寫和備份技術確保 MySQL 解決方案的高性能和高可用性
- 在 MySQL 8 中執行查詢優化、安全性和其他管理任務的全面指南

書籍描述:

MySQL 是當今世界上最受歡迎和廣泛使用的關聯式資料庫之一。最近發布的 8.0 版本帶來了一些重大進展,改變了您管理 MySQL 解決方案的方式。本手冊將成為您理解 MySQL 中新引入的功能的伴侶,以及如何利用這些功能為組織設計高性能的 MySQL 解決方案。

本書首先簡要介紹了 MySQL 8 中新引入的功能,然後迅速轉向您在日常工作中會發現有用的關鍵管理主題。本書涵蓋了遷移到 MySQL 8、MySQL 基準測試、通過實施索引技術實現高性能以及優化查詢等主題。您還將學習如何執行複寫、擴展 MySQL 解決方案並實施有效的安全技術。本書還涵蓋了常見和不太常見的故障排除技術,以實現有效的 MySQL 管理。

通過閱讀本實用的書籍,您將獲得解決任何可能在管理 MySQL 解決方案時遇到的問題所需的所有知識。

您將學到什麼:

- 根據內容類型和存儲需求了解不同的 MySQL 8 資料類型
- 最佳實踐以最佳使用 MySQL 8 的功能
- 探索全球化配置和緩存技術以提高性能
- 根據系統需求創建自定義存儲引擎
- 學習不同的索引實現方式,適用於快閃記憶體存儲
- 配置和實施複寫,以及使用複寫作為解決方案的方法
- 瞭解如何使您的 MySQL 8 解決方案高度可用
- 解決常見問題並識別使用 MySQL 8 時的錯誤碼

本書適合對 MySQL 管理相關任務有興趣的 MySQL 管理員。如果您是一名想開始進行 MySQL 管理的資料庫管理員,本書也將對您有所幫助。需要具備基本的資料庫概念知識才能開始閱讀本書。