MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The functions described in the following sections are used with MySQL Replication.
Table 14.24 Replication Functions
| Name | Description | Introduced | Deprecated |
|---|---|---|---|
asynchronous_connection_failover_add_managed() |
Add group member source server configuration information to a replication channel source list | 8.0.23 | |
asynchronous_connection_failover_add_source() |
Add source server configuration information server to a replication channel source list | 8.0.22 | |
asynchronous_connection_failover_delete_managed() |
Remove a managed group from a replication channel source list | 8.0.23 | |
asynchronous_connection_failover_delete_source() |
Remove a source server from a replication channel source list | 8.0.22 | |
asynchronous_connection_failover_reset() |
Remove all settings relating to group replication asynchronous failover | 8.0.27 | |
group_replication_disable_member_action() |
Disable member action for event specified | 8.0.26 | |
group_replication_enable_member_action() |
Enable member action for event specified | 8.0.26 | |
group_replication_get_communication_protocol() |
Get version of group replication communication protocol currently in use | 8.0.16 | |
group_replication_get_write_concurrency() |
Get maximum number of consensus instances currently set for group | 8.0.13 | |
group_replication_reset_member_actions() |
Reset all member actions to defaults and configuration version number to 1 | 8.0.26 | |
group_replication_set_as_primary() |
Make a specific group member the primary | 8.0.29 | |
group_replication_set_communication_protocol() |
Set version for group replication communication protocol to use | 8.0.16 | |
group_replication_set_write_concurrency() |
Set maximum number of consensus instances that can be executed in parallel | 8.0.13 | |
group_replication_switch_to_multi_primary_mode() |
Changes the mode of a group running in single-primary mode to multi-primary mode | 8.0.13 | |
group_replication_switch_to_single_primary_mode() |
Changes the mode of a group running in multi-primary mode to single-primary mode | 8.0.13 | |
GTID_SUBSET() |
Return true if all GTIDs in subset are also in set; otherwise false. | ||
GTID_SUBTRACT() |
Return all GTIDs in set that are not in subset. | ||
MASTER_POS_WAIT() |
Block until the replica has read and applied all updates up to the specified position | 8.0.26 | |
SOURCE_POS_WAIT() |
Block until the replica has read and applied all updates up to the specified position | 8.0.26 | |
WAIT_FOR_EXECUTED_GTID_SET() |
Wait until the given GTIDs have executed on the replica. | ||
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() |
Use WAIT_FOR_EXECUTED_GTID_SET().
|
8.0.18 |