10.11.10 The replication_connection_configuration Table

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 CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23).

Compared to the replication_connection_status table, replication_connection_configuration changes less frequently. It contains values that define how the replica connects to the source and that remain constant during the connection, whereas replication_connection_status contains values that change during the connection.

The replication_connection_configuration table has the following columns. The column descriptions indicate the corresponding CHANGE REPLICATION SOURCE TO | CHANGE MASTER TO options from which the column values are taken, and the table given later in this section shows the correspondence between replication_connection_configuration columns and SHOW REPLICA STATUS columns.

• CHANNEL_NAME

  The replication channel which this row is displaying. There is always a default replication channel, and more replication channels can be added. See Replication Channels for more information. (CHANGE REPLICATION SOURCE TO option: FOR CHANNEL, CHANGE MASTER TO option: FOR CHANNEL)

• HOST

  The host name of the source that the replica is connected to. (CHANGE REPLICATION SOURCE TO option: SOURCE_HOST, CHANGE MASTER TO option: MASTER_HOST)

• PORT

  The port used to connect to the source. (CHANGE REPLICATION SOURCE TO option: SOURCE_PORT, CHANGE MASTER TO option: MASTER_PORT)

• USER

  The user name of the replication user account used to connect to the source. (CHANGE REPLICATION SOURCE TO option: SOURCE_USER, CHANGE MASTER TO option: MASTER_USER)

• NETWORK_INTERFACE

  The network interface that the replica is bound to, if any. (CHANGE REPLICATION SOURCE TO option: SOURCE_BIND, CHANGE MASTER TO option: MASTER_BIND)

• AUTO_POSITION

  1 if GTID auto-positioning is in use; otherwise 0. (CHANGE REPLICATION SOURCE TO option: SOURCE_AUTO_POSITION, CHANGE MASTER TO option: MASTER_AUTO_POSITION)

• SSL_ALLOWED, SSL_CA_FILE, SSL_CA_PATH, SSL_CERTIFICATE, SSL_CIPHER, SSL_KEY, SSL_VERIFY_SERVER_CERTIFICATE, SSL_CRL_FILE, SSL_CRL_PATH

  These columns show the SSL parameters used by the replica to connect to the source, if any.

  SSL_ALLOWED has these values:

  • Yes if an SSL connection to the source is permitted

  • No if an SSL connection to the source is not permitted

  • Ignored if an SSL connection is permitted but the replica does not have SSL support enabled

  (CHANGE REPLICATION SOURCE TO options for the other SSL columns: SOURCE_SSL_CA, SOURCE_SSL_CAPATH, SOURCE_SSL_CERT, SOURCE_SSL_CIPHER, SOURCE_SSL_CRL, SOURCE_SSL_CRLPATH, SOURCE_SSL_KEY, SOURCE_SSL_VERIFY_SERVER_CERT.

  CHANGE MASTER TO options for the other SSL columns: MASTER_SSL_CA, MASTER_SSL_CAPATH, MASTER_SSL_CERT, MASTER_SSL_CIPHER, MASTER_SSL_CRL, MASTER_SSL_CRLPATH, MASTER_SSL_KEY, MASTER_SSL_VERIFY_SERVER_CERT.

• CONNECTION_RETRY_INTERVAL

  The number of seconds between connect retries. (CHANGE REPLICATION SOURCE TO option: SOURCE_CONNECT_RETRY, CHANGE MASTER TO option: MASTER_CONNECT_RETRY)

• CONNECTION_RETRY_COUNT

  The number of times the replica can attempt to reconnect to the source in the event of a lost connection. (CHANGE REPLICATION SOURCE TO option: SOURCE_RETRY_COUNT, CHANGE MASTER TO option: MASTER_RETRY_COUNT)

• HEARTBEAT_INTERVAL

  The replication heartbeat interval on a replica, measured in seconds. (CHANGE REPLICATION SOURCE TO option: SOURCE_HEARTBEAT_PERIOD, CHANGE MASTER TO option: MASTER_HEARTBEAT_PERIOD)

• TLS_VERSION

  The list of TLS protocol versions that are permitted by the replica for the replication connection. For TLS version information, see Encrypted Connection TLS Protocols and Ciphers. (CHANGE REPLICATION SOURCE TO option: SOURCE_TLS_VERSION, CHANGE MASTER TO option: MASTER_TLS_VERSION)

• TLS_CIPHERSUITES

  The list of ciphersuites that are permitted by the replica for the replication connection. For TLS ciphersuite information, see Encrypted Connection TLS Protocols and Ciphers. (CHANGE REPLICATION SOURCE TO option: SOURCE_TLS_CIPHERSUITES, CHANGE MASTER TO option: MASTER_TLS_CIPHERSUITES)

• PUBLIC_KEY_PATH

  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 sha256_password or caching_sha2_password authentication plugin. (CHANGE REPLICATION SOURCE TO option: SOURCE_PUBLIC_KEY_PATH, CHANGE MASTER TO option: MASTER_PUBLIC_KEY_PATH)

  If PUBLIC_KEY_PATH is given and specifies a valid public key file, it takes precedence over GET_PUBLIC_KEY.

• GET_PUBLIC_KEY

  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 caching_sha2_password authentication plugin. For that plugin, the source does not send the public key unless requested. (CHANGE REPLICATION SOURCE TO option: GET_SOURCE_PUBLIC_KEY, CHANGE MASTER TO option: GET_MASTER_PUBLIC_KEY)

  If PUBLIC_KEY_PATH is given and specifies a valid public key file, it takes precedence over GET_PUBLIC_KEY.

• NETWORK_NAMESPACE

  The network namespace name; empty if the connection uses the default (global) namespace. For information about network namespaces, see Network Namespace Support. This column was added in MySQL 8.0.22.

• COMPRESSION_ALGORITHM

  The permitted compression algorithms for connections to the source. (CHANGE REPLICATION SOURCE TO option: SOURCE_COMPRESSION_ALGORITHMS, CHANGE MASTER TO option: MASTER_COMPRESSION_ALGORITHMS)

  For more information, see Connection Compression Control.

  This column was added in MySQL 8.0.18.

• ZSTD_COMPRESSION_LEVEL

  The compression level to use for connections to the source that use the zstd compression algorithm. (CHANGE REPLICATION SOURCE TO option: SOURCE_ZSTD_COMPRESSION_LEVEL, CHANGE MASTER TO option: MASTER_ZSTD_COMPRESSION_LEVEL)

  For more information, see Connection Compression Control.

  This column was added in MySQL 8.0.18.

• SOURCE_CONNECTION_AUTO_FAILOVER

  Whether the asynchronous connection failover mechanism is activated for this replication channel. (CHANGE REPLICATION SOURCE TO option: SOURCE_CONNECTION_AUTO_FAILOVER, CHANGE MASTER TO option: SOURCE_CONNECTION_AUTO_FAILOVER)

  For more information, see Switching Sources and Replicas with Asynchronous Connection Failover.

  This column was added in MySQL 8.0.22.

• GTID_ONLY

  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. (CHANGE REPLICATION SOURCE TO option: GTID_ONLY, CHANGE MASTER TO option: GTID_ONLY)

  For more information, see GTIDs and Group Replication.

  This column was added in MySQL 8.0.27.

The replication_connection_configuration table has these indexes:

• Primary key on (CHANNEL_NAME)

TRUNCATE TABLE is not permitted for the replication_connection_configuration table.

The following table shows the correspondence between replication_connection_configuration columns and SHOW REPLICA STATUS columns.

replication_connection_configuration Column	SHOW REPLICA STATUS Column
CHANNEL_NAME	Channel_name
HOST	Source_Host
PORT	Source_Port
USER	Source_User
NETWORK_INTERFACE	Source_Bind
AUTO_POSITION	Auto_Position
SSL_ALLOWED	Source_SSL_Allowed
SSL_CA_FILE	Source_SSL_CA_File
SSL_CA_PATH	Source_SSL_CA_Path
SSL_CERTIFICATE	Source_SSL_Cert
SSL_CIPHER	Source_SSL_Cipher
SSL_KEY	Source_SSL_Key
SSL_VERIFY_SERVER_CERTIFICATE	Source_SSL_Verify_Server_Cert
SSL_CRL_FILE	Source_SSL_Crl
SSL_CRL_PATH	Source_SSL_Crlpath
CONNECTION_RETRY_INTERVAL	Source_Connect_Retry
CONNECTION_RETRY_COUNT	Source_Retry_Count
HEARTBEAT_INTERVAL	None
TLS_VERSION	Source_TLS_Version
PUBLIC_KEY_PATH	Source_public_key_path
GET_PUBLIC_KEY	Get_source_public_key
NETWORK_NAMESPACE	Network_Namespace
COMPRESSION_ALGORITHM	[None]
ZSTD_COMPRESSION_LEVEL	[None]
GTID_ONLY	[None]