Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.0Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 33.0Mb
HTML Download (TGZ) - 8.0Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 6.9Mb
Man Pages (TGZ) - 132.9Kb
Man Pages (Zip) - 189.5Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Replication_group_members

18.3.2 Replication_group_members

This table is used for monitoring the status of the different server instances that are tracked in the current view, or in other words are part of the group and as such are tracked by the membership service. The information is shared between all the server instances that are members of the replication group, so information on all the group members can be queried from any member.

Table 18.2 replication_group_members

Field

Description

Channel_name

The name of the Group Replication channel.

Member_id

The member server UUID. This has a different value for each member in the group. This also serves as a key because it is unique to each member.

Member_host

The network address of the group member.

Member_port

The MySQL connection port on which the group member is listening.

Member_state

The current state of the group member (which can be ONLINE, ERROR, RECOVERING, OFFLINE or UNREACHABLE).

Member_role

The role of the member in the group, either PRIMARY or SECONDARY.

Member_version

The MySQL version of the group member.


For more information about the Member_host value and its impact on the distributed recovery process, see Section 18.2.1.3, “User Credentials”.


User Comments
Sign Up Login You must be logged in to post a comment.