29.12.11.1 replication_connection_configuration 表
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.
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
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 Section 19.2.2, “Replication Channels” for more information. (
CHANGE REPLICATION SOURCE TO
option:FOR CHANNEL
) -
HOST
The host name of the source that the replica is connected to. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_HOST
) -
PORT
The port used to connect to the source. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_PORT
) -
USER
The user name of the replication user account used to connect to the source. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_USER
) -
NETWORK_INTERFACE
The network interface that the replica is bound to, if any. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_BIND
) -
AUTO_POSITION
1 if GTID auto-positioning is in use; otherwise 0. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_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
) -
-
CONNECTION_RETRY_INTERVAL
The number of seconds between connect retries. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_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
) -
HEARTBEAT_INTERVAL
The replication heartbeat interval on a replica, measured in seconds. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_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 Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_TLS_VERSION
) -
TLS_CIPHERSUITES
The list of ciphersuites that are permitted by the replica for the replication connection. For TLS ciphersuite information, see Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_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
orcaching_sha2_password
authentication plugin. (CHANGE REPLICATION SOURCE TO
option:SOURCE_PUBLIC_KEY_PATH
)If
PUBLIC_KEY_PATH
is given and specifies a valid public key file, it takes precedence overGET_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
)If
PUBLIC_KEY_PATH
is given and specifies a valid public key file, it takes precedence overGET_PUBLIC_KEY
. -
NETWORK_NAMESPACE
The network namespace name; empty if the connection uses the default (global) namespace. For information about network namespaces, see Section 7.1.14, “Network Namespace Support”.
-
COMPRESSION_ALGORITHM
The permitted compression algorithms for connections to the source. (
CHANGE REPLICATION SOURCE TO
option:SOURCE_COMPRESSION_ALGORITHMS
)For more information, see Section 6.2.8, “Connection Compression Control”.
-
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
)For more information, see Section 6.2.8, “Connection Compression Control”.
-
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
)For more information, see Section 19.4.9, “Switching Sources and Replicas with Asynchronous Connection Failover”.
-
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
)For more information, see Section 20.4.1, “GTIDs and Group Replication”.
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] |