Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 42.0Mb
PDF (A4) - 42.1Mb
Man Pages (TGZ) - 267.2Kb
Man Pages (Zip) - 376.9Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  The replication_group_communication_information Table

27.12.11.15 The replication_group_communication_information Table

This table shows group configuration options for the whole replication group. The table is available only when Group Replication is installed.

The replication_group_communication_information table has these columns:

  • WRITE_CONCURRENCY

    The maximum number of consensus instances that the group can execute in parallel. The default value is 10. See Section 18.5.1.3, “Using Group Replication Group Write Consensus”.

  • COMMUNICATION_PROTOCOL

    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 18.5.1.4, “Setting a Group's Communication Protocol Version”.

  • WRITE_CONSENSUS_LEADERS_PREFERRED

    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_leader system variable set to ON and 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”.

  • WRITE_CONSENSUS_LEADERS_ACTUAL

    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.

The replication_group_communication_information table has no indexes.

TRUNCATE TABLE is not permitted for the replication_group_communication_information table.