Rechercher dans le manuel MySQL
26.12.11.1 The replication _connection _configuration Table
This table shows the configuration parameters used by the
slave server for connecting to the master server. 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 slave connects to the master 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 17.2.3, “Replication Channels” for more information. (
CHANGE MASTER TO
option:FOR CHANNEL
)HOST
The master host that the slave is connected to. (
CHANGE MASTER TO
option:MASTER_HOST
)PORT
The port used to connect to the master. (
CHANGE MASTER TO
option:MASTER_PORT
)USER
The user name of the account used to connect to the master. (
CHANGE MASTER TO
option:MASTER_USER
)NETWORK_INTERFACE
The network interface that the slave 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 slave to connect to the master, if any.
SSL_ALLOWED
has these values:Yes
if an SSL connection to the master is permittedNo
if an SSL connection to the master is not permittedIgnored
if an SSL connection is permitted but the slave server 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 slave can attempt to reconnect to the master in the event of a lost connection. (
CHANGE MASTER TO
option:MASTER_RETRY_COUNT
)HEARTBEAT_INTERVAL
The replication heartbeat interval on a slave, measured in seconds. (
CHANGE MASTER TO
option:MASTER_HEARTBEAT_PERIOD
)TLS_VERSION
The TLS version used on the master. For TLS version information, see Section 6.3.2, “Encrypted Connection Protocols and Ciphers”. (
CHANGE MASTER TO
option:MASTER_TLS_VERSION
)PUBLIC_KEY_PATH
The path name to a file containing a slave-side copy of the public key required by the master for RSA key pair-based password exchange. The file must be in PEM format. This column applies to slaves that authenticate with the
sha256_password
orcaching_sha2_password
authentication plugin. (CHANGE MASTER TO
option:MASTER_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 master the public key required for RSA key pair-based password exchange. This column applies to slaves that authenticate with the
caching_sha2_password
authentication plugin. For that plugin, the master does not send the public key unless requested. (CHANGE MASTER TO
option:MASTER_GET_PUBLIC_KEY
)If
PUBLIC_KEY_PATH
is given and specifies a valid public key file, it takes precedence overGET_PUBLIC_KEY
.COMPRESSION_ALGORITHMS
The permitted compression algorithms for connections to the master. (
CHANGE MASTER TO
option:MASTER_COMPRESSION_ALGORITHMS
)For more information, see Section 4.2.6, “Connection Compression Control”.
This column was added in MySQL 8.0.18.
ZSTD_COMPRESSION_LEVEL
The compression level to use for connections to the master that use the
zstd
compression algorithm. (CHANGE MASTER TO
option:MASTER_ZSTD_COMPRESSION_LEVEL
)For more information, see Section 4.2.6, “Connection Compression Control”.
This column was added in MySQL 8.0.18.
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 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 |
PUBLIC_KEY_PATH |
Master_public_key_path |
GET_PUBLIC_KEY |
Get_master_public_key |
MASTER_COMPRESSION_ALGORITHMS |
[None] |
MASTER_ZSTD_COMPRESSION_LEVEL |
[None] |
Nederlandse vertaling
U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.
Bij voorbaat dank.
Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-replication-connection-configuration-table.html
De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.
Referenties
Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.