25.12.11.1 The replication_connection

25.12.11.1 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 MASTER TO statement, as indicated in the column descriptions.

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 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 SLAVE 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 Section 16.2.2, “Replication Channels” for more information. (CHANGE MASTER TO option: FOR CHANNEL)
HOST
The replication source server that the replica is connected to. (CHANGE MASTER TO option: MASTER_HOST)
PORT
The port used to connect to the replication source server. (CHANGE MASTER TO option: MASTER_PORT)
USER
The user name of the account used to connect to the replication source server. (CHANGE MASTER TO option: MASTER_USER)
NETWORK_INTERFACE
The network interface that the replica is bound to, if any. (CHANGE MASTER TO option: MASTER_BIND)
AUTO_POSITION
1 if autopositioning is in use; otherwise 0. (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 replication source server, 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 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 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 MASTER TO option: MASTER_RETRY_COUNT)
HEARTBEAT_INTERVAL
The replication heartbeat interval on a replica, measured in seconds. (CHANGE MASTER TO option: MASTER_HEARTBEAT_PERIOD)
TLS_VERSION
The TLS version used on the source. For TLS version information, see Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”. (CHANGE MASTER TO option: MASTER_TLS_VERSION)
This column was added in MySQL 5.7.10.

TRUNCATE TABLE is not permitted for the replication_connection_configuration table.

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

`replication_connection_configuration` Column	`SHOW SLAVE STATUS` Column
`CHANNEL_NAME`	`Channel_name`
`HOST`	`Master_Host`
`PORT`	`Master_Port`
`USER`	`Master_User`
`NETWORK_INTERFACE`	`Master_Bind`
`AUTO_POSITION`	`Auto_Position`
`SSL_ALLOWED`	`Master_SSL_Allowed`
`SSL_CA_FILE`	`Master_SSL_CA_File`
`SSL_CA_PATH`	`Master_SSL_CA_Path`
`SSL_CERTIFICATE`	`Master_SSL_Cert`
`SSL_CIPHER`	`Master_SSL_Cipher`
`SSL_KEY`	`Master_SSL_Key`
`SSL_VERIFY_SERVER_CERTIFICATE`	`Master_SSL_Verify_Server_Cert`
`SSL_CRL_FILE`	`Master_SSL_Crl`
`SSL_CRL_PATH`	`Master_SSL_Crlpath`
`CONNECTION_RETRY_INTERVAL`	`Connect_Retry`
`CONNECTION_RETRY_COUNT`	`Master_Retry_Count`
`HEARTBEAT_INTERVAL`	None
`TLS_VERSION`	`Master_TLS_Version`