<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-group-members-table">
      </a>
      29.12.11.16 The replication_group_members Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045070710720">
  </a>
  <a class="indexterm" name="idm46045070709216">
  </a>
  <p>
   This table shows network and status information for
          replication group members. The network addresses shown are the
          addresses used to connect clients to the group, and should not
          be confused with the member's internal group
          communication address specified by
   <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_local_address">
    <code class="literal">
     group_replication_local_address
    </code>
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-replication-group-members-table.html" title="29.12.11.16 The replication_group_members Table">
    <code class="literal">
     replication_group_members
    </code>
   </a>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       CHANNEL_NAME
      </code>
     </p>
     <p>
      Name of the Group Replication channel.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_ID
      </code>
     </p>
     <p>
      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.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_HOST
      </code>
     </p>
     <p>
      Network address of this member (host name or IP address).
              Retrieved from the member's
      <a class="link" href="server-system-variables.html#sysvar_hostname">
       <code class="literal">
        hostname
       </code>
      </a>
      variable. This
              is the address which clients connect to, unlike the
              group_replication_local_address which is used for internal
              group communication.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_PORT
      </code>
     </p>
     <p>
      Port on which the server is listening. Retrieved from the
              member's
      <a class="link" href="server-system-variables.html#sysvar_port">
       <code class="literal">
        port
       </code>
      </a>
      variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_STATE
      </code>
     </p>
     <p>
      Current state of this member; can be any one of the
              following:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          ONLINE
         </code>
         : The member is in a fully
                  functioning state.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          RECOVERING
         </code>
         : The server has joined a
                  group from which it is retrieving data.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          OFFLINE
         </code>
         : The group replication
                  plugin is installed but has not been started.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          ERROR
         </code>
         : The member has encountered
                  an error, either during applying transactions or
                  during the recovery phase, and is not participating in
                  the group's transactions.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          UNREACHABLE
         </code>
         : The failure detection
                  process suspects that this member cannot be contacted,
                  because the group messages have timed out.
        </p>
       </li>
      </ul>
     </div>
     <p>
      See
      <a class="xref" href="group-replication-server-states.html" title="20.4.2 Group Replication Server States">
       Section 20.4.2, “Group Replication Server States”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_ROLE
      </code>
     </p>
     <p>
      Role of the member in the group, either
      <code class="literal">
       PRIMARY
      </code>
      or
      <code class="literal">
       SECONDARY
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_VERSION
      </code>
     </p>
     <p>
      MySQL version of the member.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_COMMUNICATION_STACK
      </code>
     </p>
     <p>
      The communication stack used for the group, either the
      <code class="literal">
       XCOM
      </code>
      communication stack or the
      <code class="literal">
       MYSQL
      </code>
      communication stack.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-replication-group-members-table.html" title="29.12.11.16 The replication_group_members Table">
    <code class="literal">
     replication_group_members
    </code>
   </a>
   table has no indexes.
  </p>
  <p>
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   is not permitted
          for the
   <a class="link" href="performance-schema-replication-group-members-table.html" title="29.12.11.16 The replication_group_members Table">
    <code class="literal">
     replication_group_members
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
