13.4.3.3 Function which Configures Group Replication Primary

The following function enables you to configure which member of a single-primary replication group is the primary.

• 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”