Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.6Mb
PDF (A4) - 38.6Mb
PDF (RPM) - 33.4Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 134.3Kb
Man Pages (Zip) - 190.3Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Functions which Configure the Group Replication Mode

13.4.3.4 Functions which Configure the Group Replication Mode

The following functions enable you to control the mode which a replication group is running in, either single-primary or multi-primary mode.

  • group_replication_switch_to_single_primary_mode()

    Changes a group running in multi-primary mode to single-primary mode, without the need to stop Group Replication. Must be issued on a member of a replication group running in multi-primary mode.

    Syntax:

    STRING group_replication_switch_to_single_primary_mode([str])

    Arguments:

    • str: A string containing the UUID of a member of the group which should become the new single primary. Other members of the group become secondaries.

    Return value:

    Any resulting error as a string.

    Example:

    SELECT group_replication_switch_to_single_primary_mode(member_uuid);

    For more information, see Section 18.4.2.2, “Changing a Group's Mode”

  • group_replication_switch_to_multi_primary_mode()

    Changes a group running in single-primary mode to multi-primary mode. Must be issued on a member of a replication group running in single-primary mode.

    Syntax:

    STRING group_replication_switch_to_multi_primary_mode(([str])

    This function has no parameters.

    Return value:

    Any resulting error as a string.

    Example:

    SELECT group_replication_switch_to_multi_primary_mode()

    All members which belong to the group become primaries.

    For more information, see Section 18.4.2.2, “Changing a Group's Mode”


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.