group_replication_set_as_primary()

Appoints a specific member of the group as the new primary, overriding any election process. Pass in member_uuid which is the server_uuid of the member that you want to become the new primary. Must be issued on a member of a replication group running in single-primary mode.

Syntax:

STRING group_replication_set_as_primary(member_uuid)

Return value:

A string containing the result of the operation, for example whether it was successful or not.

Example:

SELECT group_replication_set_as_primary(member_uuid)

For more information, see Section 18.5.1.1, “Changing a Group's Primary Member”