Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 42.1Mb
PDF (A4) - 42.2Mb
Man Pages (TGZ) - 268.3Kb
Man Pages (Zip) - 378.1Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Function which Configures Group Replication Primary 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.


    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.


    SELECT group_replication_set_as_primary(member_uuid)

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