mysql 官方架构相关图

news/2024/9/23 21:27:58

一些来自 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发布于博客园

 

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.ryyt.cn/news/61215.html

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈,一经查实,立即删除!

相关文章

mac 中安装 homebrew

原链接:https://zhuanlan.zhihu.com/p/905081701. 写在前面curl: (7) Failed to connect to raw.githubusercontent.com port 443: Operation timed out使用官方脚本遇到上面的错误提示:请按照下面「安装步骤」步骤执行。 2. 安装步骤 如果有更换镜像源的想法,强烈推荐使用镜…

Spring框架漏洞总结

本篇文章主要是内容常见Spring漏洞的解析以及理解。目录SpEL注入攻击Spring H2 Database Console未授权访问Spring Security OAuth2远程命令执行漏洞(CVE-2016-4977)Spring WebFlow远程代码执行漏洞(CVE-2017-4971)Spring Data Rest远程命令执行漏洞(CVE-2017-8046)Spring Mess…

第一个中秋节

第一个中秋节 第一次分别 1347公里的同一轮明月 心比月光皎洁

IntelliJ IDEA内置代码文档汉化简单指南

测试环境:IntelliJ IDEA 2024.1 (Community Edition)IntelliJ IDEA,作为一款业界领先的集成开发环境(IDE),提供了丰富的代码提示和文档支持功能,极大地促进了开发者的编码效率。然而,对于中文用户,尤其是初学者,英文的代码文档提示可能会成为理解和使用的障碍。因此,将…

舞会

从中学校服到晚会礼服 前后座的小小尝试 寒风中彼此依偎 用闪光灯定格

自行车

军训的搭载给人自信 纵使还没有“名分” 也想让你体验 秋日的晚风

电影院

地铁上羞涩的小朋友 影院依偎在肩头 不懂奥本海默的政治风云 只想就着晚风 攥住你手