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 的社區版中可用，從版本 8.0.11 GA 發行開始，使本書對任何需要冗餘以防故障的 MySQL 用戶都具有相關性。本書中的教程展示了如何配置測試環境和計劃生產部署。示例以典型的 MySQL 高可用性設置的逐步指導形式提供。
您將學到的內容：
- 探索 MySQL 中最新的高可用性功能
- 設置並使用 InnoDB Cluster 作為 HA 解決方案
- 將現有伺服器遷移到 MySQL 8
- 採用最佳實踐使用 InnoDB Cluster
- 配置伺服器以實現最佳自動故障轉移，確保在伺服器故障時應用程序繼續運行
- 配置 MySQL Router 以對集群的入站連接進行負載均衡
本書適合對象：
系統工程師、開發人員和數據庫專業人士，想要了解從 MySQL 8.0.11 開始的強大高可用性 (HA) 功能：MySQL Shell、MySQL Router 和 MySQL Group Replication。本書對於設計以數據庫為支撐的高可用性系統的人士，以及對開源 HA 解決方案感興趣的人士都非常有用。
$1,840Pro MySQL NDB Cluster
