一些來自 MySQL 官網的圖片彙總。
主要是 8.4 版本的 manual。
架構圖01
Figure 18.3 MySQL Architecture with Pluggable Storage Engines
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-overview.html
架構圖02：InnoDB
InnoDB Architecture
https://dev.mysql.com/doc/refman/8.4/en/innodb-architecture.html
架構圖03：NDB Cluster
This chapter provides information about MySQL NDB Cluster, a high-availability, high-redundancy version of MySQL adapted for
the distributed computing environment, as well as information specific to NDB Cluster 8.4 (NDB 8.4.0),
based on version 8.4 of the NDB storage engine.
MySQL NDB Cluster uses the MySQL server with the NDB storage engine.
Support for the NDB storage engine is not included in standard MySQL Server 8.4 binaries built by Oracle.（注意，該方式搭建的叢集需要付費的。）
MySQL NDB Cluster does not support InnoDB Cluster, which must be deployed using MySQL Server InnoDB storage engine
as well as additional applications that are not included in the NDB Cluster distribution.
MySQL Server 8.4 binaries cannot be used with MySQL NDB Cluster.
25.2 NDB Cluster Overview
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview.html
NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system.
The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software.
Figure 25.1 NDB Cluster Components
架構圖04：InnoDB Cluster
Chapter 23 InnoDB Cluster
https://dev.mysql.com/doc/refman/8.4/en/mysql-innodb-cluster-introduction.html
This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for MySQL.
An InnoDB Cluster consists of at least three MySQL Server instances, and it provides high-availability and scaling features. InnoDB Cluster uses the following MySQL technologies:
》MySQL Shell,
which is an advanced client and code editor for MySQL.
》MySQL Server, and Group Replication,
which enables a set of MySQL instances to provide high-availability. InnoDB Cluster provides an alternative, easy to use programmatic way to work with Group Replication.
》MySQL Router,
a lightweight middleware that provides transparent routing between your application and InnoDB Cluster.
進一步閱讀：
https://dev.mysql.com/doc/mysql-shell/8.4/en/mysql-innodb-cluster.html
ben釋出於部落格園
架構圖05：源到副本的複製
20 Group Replication
20.1.1.1 Source to Replica Replication
https://dev.mysql.com/doc/refman/8.4/en/group-replication-primary-secondary-replication.html
非同步複製
半同步複製
ben釋出於部落格
園
MySQL Group Replication Protocol
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
組複製協議
翻譯：
consensus 英 [kənˈsensəs] n.共識，一致看法
relay n. 接力比賽; 中繼裝置; 輪換者 v. 轉播; 轉述; 轉送
-
找圖的簡便方法
方法：下載 PDF，搜尋“Figure ”——設定區分大小寫，即可。
注，上面的圖都是 透過搜尋引擎找的，很麻煩、費時。
示例：WPS PDF，8.0 的 manual——6302頁（搜尋時，膝上型電腦風扇轉的更快了，呼呼的）。
---end---
ben釋出於部落格園
ben釋出於部落格園