文档首页
MySQL 8.4 参考手册
8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文,英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成,仅供理解参考;有疑问请以官方英文原文为准。

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 62%

14.18 复制功能14.18 Replication Functions

以下各节中描述的函数用于 MySQL 复制。The functions described in the following sections are used with MySQL Replication.

表 14.24 复制函数Table 14.24 Replication Functions

名称Name 说明Description 已弃用Deprecated
asynchronous_connection_failover_add_managed() 将组成员源服务器配置信息添加到复制通道源列表Add group member source server configuration information to a replication channel source list
asynchronous_connection_failover_add_source() 将源服务器配置信息服务器添加到复制通道源列表Add source server configuration information server to a replication channel source list
asynchronous_connection_failover_delete_managed() 从复制通道源列表中移除托管组Remove a managed group from a replication channel source list
asynchronous_connection_failover_delete_source() 从复制通道源列表中移除源服务器Remove a source server from a replication channel source list
asynchronous_connection_failover_reset() 删除所有与组复制异步故障切换相关的设置Remove all settings relating to group replication asynchronous failover
group_replication_disable_member_action() 为指定事件禁用成员操作Disable member action for event specified
group_replication_enable_member_action() 为指定事件启用会员操作Enable member action for event specified
group_replication_get_communication_protocol() 获取当前使用的组复制通信协议版本Get version of group replication communication protocol currently in use
group_replication_get_write_concurrency() 获取当前为组设置的最大共识实例数Get maximum number of consensus instances currently set for group
group_replication_reset_member_actions() 将所有成员操作重置为默认,并将配置版本号重置为 1Reset all member actions to defaults and configuration version number to 1
group_replication_set_as_primary() 将特定群组成员设为主要成员Make a specific group member the primary
group_replication_set_communication_protocol() 设置群组复制通信协议使用的版本Set version for group replication communication protocol to use
group_replication_set_write_concurrency() 设置可以并行执行的最大共识实例数Set maximum number of consensus instances that can be executed in parallel
group_replication_switch_to_multi_primary_mode() 将以单主模式运行的组的模式更改为多主模式Changes the mode of a group running in single-primary mode to multi-primary mode
group_replication_switch_to_single_primary_mode() 将以多主模式运行的组的模式更改为单主模式Changes the mode of a group running in multi-primary mode to single-primary mode
MASTER_POS_WAIT() 阻塞,直到副本已读取并应用到指定位置的所有更新Block until the replica has read and applied all updates up to the specified position 是Yes
SOURCE_POS_WAIT() 阻塞,直到副本已读取并应用到指定位置的所有更新Block until the replica has read and applied all updates up to the specified position
WAIT_FOR_EXECUTED_GTID_SET() 等待给定的 GTID 在副本上执行完毕。Wait until the given GTIDs have executed on the replica.