This table shows group configuration options for the whole replication group. The table is available only when Group Replication is installed.
table has these columns:
The maximum number of consensus instances that the group can execute in parallel. The default value is 10. See Section 22.214.171.124, “Using Group Replication Group Write Consensus”.
The Group Replication communication protocol version, which determines what messaging capabilities are used. This is set to accommodate the oldest MySQL Server version that you want the group to support. See Section 126.96.36.199, “Setting a Group's Communication Protocol Version”.
The leader or leaders that Group Replication has instructed the group communication engine to use to drive consensus. For a group in single-primary mode with the
group_replication_paxos_single_leadersystem variable set to
ONand the communication protocol version set to 8.0.27 or above, the single consensus leader is the group’s primary. Otherwise, all group members are used as leaders, so they are all shown here. See Section 18.7.3, “Single Consensus Leader”.
The actual leader or leader that the group communication engine is using to drive consensus. If a single consensus leader is in use for the group, and the primary is currently unhealthy, the group communication selects an alternative consensus leader. In this situation, the group member specified here can differ from the preferred group member.
Whether the replication group is capable of using a single consensus leader. 1 means that the group was started with the use of a single leader enabled (
group_replication_paxos_single_leader = ON), and this is still shown if the value of
group_replication_paxos_single_leaderhas since been changed on this group member. 0 means that the group was started with single leader mode disabled (
group_replication_paxos_single_leader = OFF), or has a Group Replication communication protocol version that does not support the use of a single consensus leader (below 8.0.27). This information is only returned for group members in
table has no indexes.
TRUNCATE TABLE is not permitted