MySQL 8.4 Release Notes
以下各节中描述的函数用于 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. |