Introducing InnoDB Cluster: Learning the MySQL High Availability Stack

Charles Bell

  • 出版商: Apress
  • 出版日期: 2018-09-08
  • 定價: $1,650
  • 售價: 9.5$1,568
  • 貴賓價: 9.0$1,485
  • 語言: 英文
  • 頁數: 488
  • 裝訂: Paperback
  • ISBN: 1484238842
  • ISBN-13: 9781484238844
  • 相關分類: MySQLSQL
  • 立即出貨 (庫存=1)

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

商品描述

Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. 

Introducing InnoDB Cluster teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works together to ensure that your data are available even when your primary database server goes down. 

Features described in this book are available in the Community Edition of MySQL, beginning with the version 8.0.11 GA release, making this book relevant for any MySQL users in need of redundancy against failure. Tutorials in the book show how to configure a test environment and plan a production deployment. Examples are provided in the form of a walk-through of a typical MySQL high-availability setup.

What You'll Learn
  • Discover the newest high-availability features in MySQL
  • Set up and use InnoDB Cluster as an HA solution
  • Migrate your existing servers to MySQL 8
  • Employ best practices for using InnoDB Cluster
  • Configure servers for optimal automatic failover to ensure that applications continue when a server fails
  • Configure MySQL Router to load-balance inbound connections to the cluster
Who This Book Is For

Systems engineers, developers, and database professionals wanting to learn about the powerful high availability (HA) features, beginning with MySQL 8.0.11: MySQL Shell, MySQL Router, and MySQL Group Replication. The book is useful for those designing high-availability systems backed by a database, and for those interested in open source HA solutions. 

商品描述(中文翻譯)

在Oracle的MySQL中,設置、管理和配置新的InnoDB Cluster功能。如果您正在擴展MySQL安裝並希望探索使您的伺服器高度可用的方法,本書提供了關於高可用性和MySQL 8.0.11及更高版本中可用的新工具的相關資訊。

《介紹InnoDB Cluster》將教您有關構成InnoDB Cluster的基本組件,例如用於冗餘存儲數據的MySQL Group Replication,用於入站連接路由的MySQL Router,以及用於簡化設置和配置、狀態報告甚至自動故障轉移的MySQL Shell。您將了解它們如何協同工作,以確保在主要數據庫伺服器故障時,您的數據仍然可用。

本書介紹的功能在MySQL的Community Edition中可用,從8.0.11 GA版本開始,因此對於需要防止故障的任何MySQL使用者都具有相關性。本書中的教程展示了如何配置測試環境並計劃生產部署。通過典型MySQL高可用性設置的實例進行了演示。

您將學到以下內容:
- 探索MySQL中最新的高可用性功能
- 使用InnoDB Cluster作為高可用性解決方案
- 將現有伺服器遷移到MySQL 8
- 使用最佳實踐來使用InnoDB Cluster
- 配置伺服器以實現最佳的自動故障轉移,確保應用程式在伺服器故障時繼續運行
- 配置MySQL Router以將入站連接平衡到集群

本書適合以下讀者:
- 系統工程師、開發人員和資料庫專業人員,希望了解MySQL 8.0.11開始的強大高可用性功能:MySQL Shell、MySQL Router和MySQL Group Replication。本書對於設計以資料庫為後端的高可用性系統的人以及對開源高可用性解決方案感興趣的人都很有用。