- 7.6.1 安装和卸载插件7.6.1 Installing and Uninstalling Plugins
- 7.6.2 获取服务器插件信息7.6.2 Obtaining Server Plugin Information
- 7.6.3 MySQL 企业线程池7.6.3 MySQL Enterprise Thread Pool
- 7.6.4 重写器查询重写插件7.6.4 The Rewriter Query Rewrite Plugin
- 7.6.5 ddl_rewriter 插件7.6.5 The ddl_rewriter Plugin
- 7.6.6 版本标记7.6.6 Version Tokens
- 7.6.7 克隆插件7.6.7 The Clone Plugin
- 7.6.8 密钥环代理桥插件7.6.8 The Keyring Proxy Bridge Plugin
- 7.6.9 MySQL 插件服务7.6.9 MySQL Plugin Services
MySQL 支持一个插件 API,使得可以创建服务器插件。插件可以在服务器启动时加载,也可以在运行时加载和卸载而无需重启服务器。通过该接口支持的插件包括但不限于存储引擎、INFORMATION_SCHEMA 表、全文解析器插件和服务器扩展。MySQL supports an plugin API that enables creation of server
plugins. Plugins can be loaded at server startup, or loaded and
unloaded at runtime without restarting the server. The plugins
supported by this interface include, but are not limited to, storage
engines, INFORMATION_SCHEMA tables, full-text
parser plugins, and server extensions.
MySQL 发行版包含几个实现服务器扩展的插件:MySQL distributions include several plugins that implement server extensions:
用于验证客户端尝试连接到 MySQL 服务器的插件。多种身份验证协议都提供了插件。参见 第 8.2.17 节,“可插拔身份验证”。Plugins for authenticating attempts by clients to connect to MySQL Server. Plugins are available for several authentication protocols. See Section 8.2.17, “Pluggable Authentication”.
一种连接控制插件,使管理员能够在一定次数的连续客户端连接失败后引入逐渐增加的延迟。参见 第 8.4.2 节,“连接控制插件”。A connection control plugin that enables administrators to introduce an increasing delay after a certain number of consecutive failed client connection attempts. See Section 8.4.2, “Connection Control Plugins”.
密码验证插件实现密码强度策略,并评估潜在密码的强度。参见 第 8.4.3 节,“密码验证组件”。A password-validation plugin implements password strength policies and assesses the strength of potential passwords. See Section 8.4.3, “The Password Validation Component”.
半同步复制插件实现了一个复制功能接口,该接口允许源在至少一个副本对每个事务作出响应后继续执行。见 第 19.4.10 节,“半同步复制”。Semisynchronous replication plugins implement an interface to replication capabilities that permit the source to proceed as long as at least one replica has responded to each transaction. See Section 19.4.10, “Semisynchronous Replication”.
组复制使您能够在一组 MySQL 服务器实例之间创建高度可用的分布式 MySQL 服务,内置数据一致性、冲突检测与解决以及组成员管理服务。参见第 20 章,组复制。Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and resolution, and group membership services all built-in. See Chapter 20, Group Replication.
MySQL 企业版包含一个线程池插件,该插件管理连接线程,通过高效管理大量客户端连接的语句执行线程来提高服务器性能。见 第 7.6.3 节,“MySQL 企业线程池”。MySQL Enterprise Edition includes a thread pool plugin that manages connection threads to increase server performance by efficiently managing statement execution threads for large numbers of client connections. See Section 7.6.3, “MySQL Enterprise Thread Pool”.
MySQL 企业版包括一个审计插件,用于监控和记录连接及查询活动。见 第 8.4.5 节,“MySQL 企业审计”。MySQL Enterprise Edition includes an audit plugin for monitoring and logging of connection and query activity. See Section 8.4.5, “MySQL Enterprise Audit”.
MySQL 企业版包含一个防火墙插件,该插件实现了应用级防火墙,使数据库管理员能够根据与允许的语句模式列表的匹配情况,允许或拒绝 SQL 语句的执行。请参见 第 8.4.7 节,“MySQL 企业防火墙”。MySQL Enterprise Edition includes a firewall plugin that implements an application-level firewall to enable database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. See Section 8.4.7, “MySQL Enterprise Firewall”.
查询重写插件会检查 MySQL 服务器接收到的语句,并可能在服务器执行之前对其进行重写。请参见 第 7.6.4 节,“重写器查询重写插件”,以及 第 7.6.5 节,“ddl_rewriter 插件”。Query rewrite plugins examine statements received by MySQL Server and possibly rewrite them before the server executes them. See Section 7.6.4, “The Rewriter Query Rewrite Plugin”, and Section 7.6.5, “The ddl_rewriter Plugin”.
版本令牌允许创建和围绕服务器令牌进行同步,应用程序可以使用这些令牌来防止访问错误或过时的数据。版本令牌基于一个插件库,该库实现了一个
version_tokens插件和一组可加载函数。参见第 7.6.6 节,“版本令牌”。Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. Version Tokens is based on a plugin library that implements aversion_tokensplugin and a set of loadable functions. See Section 7.6.6, “Version Tokens”.密钥环插件为敏感信息提供安全存储。参见第 8.4.4 节,“MySQL 密钥环”。Keyring plugins provide secure storage for sensitive information. See Section 8.4.4, “The MySQL Keyring”.
X 插件扩展了 MySQL 服务器,使其能够作为文档存储运行。运行 X 插件可使 MySQL 服务器使用 X 协议与客户端通信,该协议旨在将 MySQL 的 ACID 合规存储能力呈现为文档存储。参见第 22.5 节,“X 插件”。X Plugin extends MySQL Server to be able to function as a document store. Running X Plugin enables MySQL Server to communicate with clients using the X Protocol, which is designed to expose the ACID compliant storage abilities of MySQL as a document store. See Section 22.5, “X Plugin”.
Clone 允许从本地或远程 MySQL 服务器实例克隆
InnoDB数据。请参见 第 7.6.7 节,“克隆插件”。Clone permits cloningInnoDBdata from a local or remote MySQL server instance. See Section 7.6.7, “The Clone Plugin”.测试框架插件用于测试服务器服务。有关这些插件的信息,请参阅 MySQL 服务器 Doxygen 文档中的测试插件服务插件部分,可访问 https://dev.mysql.com/doc/index-other.html。Test framework plugins test server services. For information about these plugins, see the Plugins for Testing Plugin Services section of the MySQL Server Doxygen documentation, available at https://dev.mysql.com/doc/index-other.html.
以下各节描述了如何安装和卸载插件,以及如何在运行时确定已安装的插件并获取有关它们的信息。有关编写插件的信息,请参阅 MySQL 插件 API。The following sections describe how to install and uninstall plugins, and how to determine at runtime which plugins are installed and obtain information about them. For information about writing plugins, see The MySQL Plugin API.