Rechercher dans le manuel MySQL

26.12.11.1 The replication _connection _configuration Table

Inhaltsverzeichnis

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 permitted

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

    • Ignored 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 or caching_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 over GET_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 over GET_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]

Suchen Sie im MySQL-Handbuch

Deutsche Übersetzung

Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.

Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.

Vielen Dank im Voraus.

Dokument erstellt 26/06/2006, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/mysql-rf-replication-connection-configuration-table.html

Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.

Referenzen

  1. Zeigen Sie - html-Dokument Sprache des Dokuments:en Manuel MySQL : https://dev.mysql.com/

Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.

Inhaltsverzeichnis Haut