<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-connection-configuration-table">
      </a>
      29.12.11.11 The replication_connection_configuration Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045071112016">
  </a>
  <a class="indexterm" name="idm46045071110512">
  </a>
  <p>
   This table shows the configuration parameters used by the
          replica for connecting to the source. Parameters stored in the
          table can be changed at runtime with the
   <a class="link" href="change-replication-source-to.html" title="15.4.2.2 CHANGE REPLICATION SOURCE TO Statement">
    <code class="literal">
     CHANGE REPLICATION SOURCE TO
    </code>
   </a>
   statement.
  </p>
  <p>
   Compared to the
   <a class="link" href="performance-schema-replication-connection-status-table.html" title="29.12.11.13 The replication_connection_status Table">
    <code class="literal">
     replication_connection_status
    </code>
   </a>
   table,
   <a class="link" href="performance-schema-replication-connection-configuration-table.html" title="29.12.11.11 The replication_connection_configuration Table">
    <code class="literal">
     replication_connection_configuration
    </code>
   </a>
   changes less frequently. It contains values that define how
          the replica connects to the source and that remain constant
          during the connection, whereas
   <a class="link" href="performance-schema-replication-connection-status-table.html" title="29.12.11.13 The replication_connection_status Table">
    <code class="literal">
     replication_connection_status
    </code>
   </a>
   contains values that change during the connection.
  </p>
  <p>
   The
   <a class="link" href="performance-schema-replication-connection-configuration-table.html" title="29.12.11.11 The replication_connection_configuration Table">
    <code class="literal">
     replication_connection_configuration
    </code>
   </a>
   table has the following columns. The column descriptions
          indicate the corresponding
   <a class="link" href="change-replication-source-to.html" title="15.4.2.2 CHANGE REPLICATION SOURCE TO Statement">
    <code class="literal">
     CHANGE
          REPLICATION SOURCE TO
    </code>
   </a>
   options from which the column
          values are taken, and the table given later in this section
          shows the correspondence between
   <a class="link" href="performance-schema-replication-connection-configuration-table.html" title="29.12.11.11 The replication_connection_configuration Table">
    <code class="literal">
     replication_connection_configuration
    </code>
   </a>
   columns and
   <a class="link" href="show-replica-status.html" title="15.7.7.35 SHOW REPLICA STATUS Statement">
    <code class="literal">
     SHOW
          REPLICA STATUS
    </code>
   </a>
   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 which this row is displaying.
              There is always a default replication channel, and more
              replication channels can be added. See
      <a class="xref" href="replication-channels.html" title="19.2.2 Replication Channels">
       Section 19.2.2, “Replication Channels”
      </a>
      for more
              information. (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       FOR CHANNEL
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       HOST
      </code>
     </p>
     <p>
      The host name of the source that the replica is connected
              to. (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_HOST
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PORT
      </code>
     </p>
     <p>
      The port used to connect to the source. (
      <code class="literal">
       CHANGE
              REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_PORT
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       USER
      </code>
     </p>
     <p>
      The user name of the replication user account used to
              connect to the source. (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       SOURCE_USER
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NETWORK_INTERFACE
      </code>
     </p>
     <p>
      The network interface that the replica is bound to, if
              any. (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_BIND
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       AUTO_POSITION
      </code>
     </p>
     <p>
      1 if GTID auto-positioning is in use; otherwise 0.
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_AUTO_POSITION
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SSL_ALLOWED
      </code>
      ,
      <code class="literal">
       SSL_CA_FILE
      </code>
      ,
      <code class="literal">
       SSL_CA_PATH
      </code>
      ,
      <code class="literal">
       SSL_CERTIFICATE
      </code>
      ,
      <code class="literal">
       SSL_CIPHER
      </code>
      ,
      <code class="literal">
       SSL_KEY
      </code>
      ,
      <code class="literal">
       SSL_VERIFY_SERVER_CERTIFICATE
      </code>
      ,
      <code class="literal">
       SSL_CRL_FILE
      </code>
      ,
      <code class="literal">
       SSL_CRL_PATH
      </code>
     </p>
     <p>
      These columns show the SSL parameters used by the replica
              to connect to the source, if any.
     </p>
     <p>
      <code class="literal">
       SSL_ALLOWED
      </code>
      has these values:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          Yes
         </code>
         if an SSL connection to the
                  source is permitted
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          No
         </code>
         if an SSL connection to the
                  source is not permitted
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Ignored
         </code>
         if an SSL connection is
                  permitted but the replica does not have SSL support
                  enabled
        </p>
       </li>
      </ul>
     </div>
     <p>
      (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      options
              for the other SSL columns:
      <code class="literal">
       SOURCE_SSL_CA
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_CAPATH
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_CERT
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_CIPHER
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_CRL
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_CRLPATH
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_KEY
      </code>
      ,
      <code class="literal">
       SOURCE_SSL_VERIFY_SERVER_CERT
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CONNECTION_RETRY_INTERVAL
      </code>
     </p>
     <p>
      The number of seconds between connect retries.
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_CONNECT_RETRY
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CONNECTION_RETRY_COUNT
      </code>
     </p>
     <p>
      The number of times the replica can attempt to reconnect
              to the source in the event of a lost connection.
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_RETRY_COUNT
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       HEARTBEAT_INTERVAL
      </code>
     </p>
     <p>
      The replication heartbeat interval on a replica, measured
              in seconds. (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       SOURCE_HEARTBEAT_PERIOD
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TLS_VERSION
      </code>
     </p>
     <p>
      The list of TLS protocol versions that are permitted by
              the replica for the replication connection. For TLS
              version information, see
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_TLS_VERSION
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TLS_CIPHERSUITES
      </code>
     </p>
     <p>
      The list of ciphersuites that are permitted by the replica
              for the replication connection. For TLS ciphersuite
              information, see
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_TLS_CIPHERSUITES
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PUBLIC_KEY_PATH
      </code>
     </p>
     <p>
      The path name to a file containing a replica-side copy of
              the public key required by the source for RSA key
              pair-based password exchange. The file must be in PEM
              format. This column applies to replicas that authenticate
              with the
      <code class="literal">
       sha256_password
      </code>
      (deprecated)
              or
      <code class="literal">
       caching_sha2_password
      </code>
      authentication
              plugin. (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_PUBLIC_KEY_PATH
      </code>
      )
     </p>
     <p>
      If
      <code class="literal">
       PUBLIC_KEY_PATH
      </code>
      is given and
              specifies a valid public key file, it takes precedence
              over
      <code class="literal">
       GET_PUBLIC_KEY
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GET_PUBLIC_KEY
      </code>
     </p>
     <p>
      Whether to request from the source the public key required
              for RSA key pair-based password exchange. This column
              applies to replicas that authenticate with the
      <code class="literal">
       caching_sha2_password
      </code>
      authentication
              plugin. For that plugin, the source does not send the
              public key unless requested. (
      <code class="literal">
       CHANGE REPLICATION
              SOURCE TO
      </code>
      option:
      <code class="literal">
       GET_SOURCE_PUBLIC_KEY
      </code>
      )
     </p>
     <p>
      If
      <code class="literal">
       PUBLIC_KEY_PATH
      </code>
      is given and
              specifies a valid public key file, it takes precedence
              over
      <code class="literal">
       GET_PUBLIC_KEY
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NETWORK_NAMESPACE
      </code>
     </p>
     <p>
      The network namespace name; empty if the connection uses
              the default (global) namespace. For information about
              network namespaces, see
      <a class="xref" href="network-namespace-support.html" title="7.1.14 Network Namespace Support">
       Section 7.1.14, “Network Namespace Support”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COMPRESSION_ALGORITHM
      </code>
     </p>
     <p>
      The permitted compression algorithms for connections to
              the source. (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       SOURCE_COMPRESSION_ALGORITHMS
      </code>
      )
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ZSTD_COMPRESSION_LEVEL
      </code>
     </p>
     <p>
      The compression level to use for connections to the source
              that use the
      <code class="literal">
       zstd
      </code>
      compression
              algorithm. (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       SOURCE_ZSTD_COMPRESSION_LEVEL
      </code>
      )
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SOURCE_CONNECTION_AUTO_FAILOVER
      </code>
     </p>
     <p>
      Whether the asynchronous connection failover mechanism is
              activated for this replication channel. (
      <code class="literal">
       CHANGE
              REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_CONNECTION_AUTO_FAILOVER
      </code>
      )
     </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>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GTID_ONLY
      </code>
     </p>
     <p>
      Indicates if this channel only uses GTIDs for the
              transaction queueing and application process and for
              recovery, and does not persist binary log and relay log
              file names and file positions in the replication metadata
              repositories. (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       GTID_ONLY
      </code>
      )
     </p>
     <p>
      For more information, see
      <a class="xref" href="group-replication-gtids.html" title="20.4.1 GTIDs and Group Replication">
       Section 20.4.1, “GTIDs and Group Replication”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-replication-connection-configuration-table.html" title="29.12.11.11 The replication_connection_configuration Table">
    <code class="literal">
     replication_connection_configuration
    </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
      </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-connection-configuration-table.html" title="29.12.11.11 The replication_connection_configuration Table">
    <code class="literal">
     replication_connection_configuration
    </code>
   </a>
   table.
  </p>
  <p>
   The following table shows the correspondence between
   <a class="link" href="performance-schema-replication-connection-configuration-table.html" title="29.12.11.11 The replication_connection_configuration Table">
    <code class="literal">
     replication_connection_configuration
    </code>
   </a>
   columns and
   <a class="link" href="show-replica-status.html" title="15.7.7.35 SHOW REPLICA STATUS Statement">
    <code class="literal">
     SHOW
          REPLICA STATUS
    </code>
   </a>
   columns.
  </p>
  <div class="informaltable">
   <table summary="Correspondence between replication_connection_configuration columns and SHOW REPLICA STATUS columns">
    <colgroup>
     <col style="width: 60%"/>
     <col style="width: 40%"/>
    </colgroup>
    <thead>
     <tr>
      <th>
       <code class="literal">
        replication_connection_configuration
       </code>
       Column
      </th>
      <th>
       <code class="literal">
        SHOW REPLICA STATUS
       </code>
       Column
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <code class="literal">
        CHANNEL_NAME
       </code>
      </td>
      <td>
       <code class="literal">
        Channel_name
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        HOST
       </code>
      </td>
      <td>
       <code class="literal">
        Source_Host
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        PORT
       </code>
      </td>
      <td>
       <code class="literal">
        Source_Port
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        USER
       </code>
      </td>
      <td>
       <code class="literal">
        Source_User
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        NETWORK_INTERFACE
       </code>
      </td>
      <td>
       <code class="literal">
        Source_Bind
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        AUTO_POSITION
       </code>
      </td>
      <td>
       <code class="literal">
        Auto_Position
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_ALLOWED
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Allowed
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_CA_FILE
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_CA_File
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_CA_PATH
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_CA_Path
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_CERTIFICATE
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Cert
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_CIPHER
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Cipher
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_KEY
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Key
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_VERIFY_SERVER_CERTIFICATE
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Verify_Server_Cert
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_CRL_FILE
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Crl
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SSL_CRL_PATH
       </code>
      </td>
      <td>
       <code class="literal">
        Source_SSL_Crlpath
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        CONNECTION_RETRY_INTERVAL
       </code>
      </td>
      <td>
       <code class="literal">
        Source_Connect_Retry
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        CONNECTION_RETRY_COUNT
       </code>
      </td>
      <td>
       <code class="literal">
        Source_Retry_Count
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        HEARTBEAT_INTERVAL
       </code>
      </td>
      <td>
       None
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        TLS_VERSION
       </code>
      </td>
      <td>
       <code class="literal">
        Source_TLS_Version
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        PUBLIC_KEY_PATH
       </code>
      </td>
      <td>
       <code class="literal">
        Source_public_key_path
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        GET_PUBLIC_KEY
       </code>
      </td>
      <td>
       <code class="literal">
        Get_source_public_key
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        NETWORK_NAMESPACE
       </code>
      </td>
      <td>
       <code class="literal">
        Network_Namespace
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        COMPRESSION_ALGORITHM
       </code>
      </td>
      <td>
       [None]
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        ZSTD_COMPRESSION_LEVEL
       </code>
      </td>
      <td>
       [None]
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        GTID_ONLY
       </code>
      </td>
      <td>
       [None]
      </td>
     </tr>
    </tbody>
   </table>
  </div>
  <div class="informaltable">
   <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 608px;">
    <thead>
     <tr>
      <th style="width: 363.953px;">
       <code class="literal">
        replication_connection_configuration
       </code>
       Column
      </th>
      <th style="width: 242.641px;">
       <code class="literal">
        SHOW REPLICA STATUS
       </code>
       Column
      </th>
     </tr>
    </thead>
   </table>
  </div>
 </div>
 <br/>
</div>
