<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-asynchronous-connection-failover-table">
      </a>
      29.12.11.8 The replication_asynchronous_connection_failover Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045071216944">
  </a>
  <a class="indexterm" name="idm46045071215424">
  </a>
  <p>
   This table holds the replica's source lists for each
          replication channel for the asynchronous connection failover
          mechanism. The asynchronous connection failover mechanism
          automatically establishes an asynchronous (source to replica)
          replication connection to a new source from the appropriate
          list after the existing connection from the replica to its
          source fails. When asynchronous connection failover is enabled
          for a group of replicas managed by Group Replication, the
          source lists are broadcast to all group members when they
          join, and also when the lists change.
  </p>
  <p>
   You set and manage source lists using the
   <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-add-source">
    <code class="literal">
     asynchronous_connection_failover_add_source
    </code>
   </a>
   and
   <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-delete-source">
    <code class="literal">
     asynchronous_connection_failover_delete_source
    </code>
   </a>
   functions to add and remove replication source servers from
          the source list for a replication channel. To add and remove
          managed groups of servers, use the
   <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-add-managed">
    <code class="literal">
     asynchronous_connection_failover_add_managed
    </code>
   </a>
   and
   <a class="link" href="replication-functions-async-failover.html#function_asynchronous-connection-failover-delete-managed">
    <code class="literal">
     asynchronous_connection_failover_delete_managed
    </code>
   </a>
   functions instead.
  </p>
  <p>
   For more information, see
   <a class="xref" href="replication-asynchronous-connection-failover.html" title="19.4.9 Switching Sources and Replicas with Asynchronous Connection Failover">
    Section 19.4.9, “Switching Sources and Replicas with Asynchronous Connection Failover”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-replication-asynchronous-connection-failover-table.html" title="29.12.11.8 The replication_asynchronous_connection_failover Table">
    <code class="literal">
     replication_asynchronous_connection_failover
    </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>
      The replication channel for which this replication source
              server is part of the source list. If this channel's
              connection to its current source fails, this replication
              source server is one of its potential new sources.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       HOST
      </code>
     </p>
     <p>
      The host name for this replication source server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PORT
      </code>
     </p>
     <p>
      The port number for this replication source server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NETWORK_NAMESPACE
      </code>
     </p>
     <p>
      The network namespace for this replication source server.
              If this value is empty, connections use the default
              (global) namespace.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       WEIGHT
      </code>
     </p>
     <p>
      The priority of this replication source server in the
              replication channel's source list. The weight is from
              1 to 100, with 100 being the highest, and 50 being the
              default. When the asynchronous connection failover
              mechanism activates, the source with the highest weight
              setting among the alternative sources listed in the source
              list for the channel is chosen for the first connection
              attempt. If this attempt does not work, the replica tries
              with all the listed sources in descending order of weight,
              then starts again from the highest weighted source. If
              multiple sources have the same weight, the replica orders
              them randomly.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MANAGED_NAME
      </code>
     </p>
     <p>
      The identifier for the managed group that the server is a
              part of. For the
      <code class="literal">
       GroupReplication
      </code>
      managed service, the identifier is the value of the
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_group_name">
       <code class="literal">
        group_replication_group_name
       </code>
      </a>
      system variable.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-replication-asynchronous-connection-failover-table.html" title="29.12.11.8 The replication_asynchronous_connection_failover Table">
    <code class="literal">
     replication_asynchronous_connection_failover
    </code>
   </a>
   table has these indexes:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Primary key on (
      <code class="literal">
       CHANNEL_NAME, HOST, PORT,
              NETWORK_NAMESPACE, MANAGED_NAME
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <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-asynchronous-connection-failover-table.html" title="29.12.11.8 The replication_asynchronous_connection_failover Table">
    <code class="literal">
     replication_asynchronous_connection_failover
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
