Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / Functions and Operators  /  Replication Functions

14.18 Replication Functions

The functions described in the following sections are used with MySQL Replication.

Table 14.24 Replication Functions

NameDescriptionIntroducedDeprecated
asynchronous_connection_failover_add_managed() Add group member source server configuration information to a replication channel source list8.0.23
asynchronous_connection_failover_add_source() Add source server configuration information server to a replication channel source list8.0.22
asynchronous_connection_failover_delete_managed() Remove a managed group from a replication channel source list8.0.23
asynchronous_connection_failover_delete_source() Remove a source server from a replication channel source list8.0.22
asynchronous_connection_failover_reset() Remove all settings relating to group replication asynchronous failover8.0.27
group_replication_disable_member_action() Disable member action for event specified8.0.26
group_replication_enable_member_action() Enable member action for event specified8.0.26
group_replication_get_communication_protocol() Get version of group replication communication protocol currently in use8.0.16
group_replication_get_write_concurrency() Get maximum number of consensus instances currently set for group8.0.13
group_replication_reset_member_actions() Reset all member actions to defaults and configuration version number to 18.0.26
group_replication_set_as_primary() Make a specific group member the primary8.0.29
group_replication_set_communication_protocol() Set version for group replication communication protocol to use8.0.16
group_replication_set_write_concurrency() Set maximum number of consensus instances that can be executed in parallel8.0.13
group_replication_switch_to_multi_primary_mode() Changes the mode of a group running in single-primary mode to multi-primary mode8.0.13
group_replication_switch_to_single_primary_mode() Changes the mode of a group running in multi-primary mode to single-primary mode8.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 position8.0.26
SOURCE_POS_WAIT() Block until the replica has read and applied all updates up to the specified position8.0.26
WAIT_FOR_EXECUTED_GTID_SET() Wait until the given GTIDs have executed on the replica.
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() UseWAIT_FOR_EXECUTED_GTID_SET().8.0.18