Performance Schema replication_connection_configuration Table
MariaDB starting with 10.5.2
The replication_connection_configuration table was added in MariaDB 10.6.0.
The Performance Schema replication_connection_configuration table displays replica's configuration settings used for connecting to the primary.
It contains the following fields.
| Column | Type | Null | Description |
|---|---|---|---|
| CHANNEL_NAME | varchar(256) | NO | The replication channel used. |
| HOST | char(60) | NO | The host name of the source that the replica is connected to. |
| PORT | int(11) | NO | The port used to connect to the source. |
| USER | char(32) | NO | The user name of the replication user account used to connect to the source. |
| USING_GTID | enum('NO', 'CURRENT_POS', 'SLAVE_POS') | NO | Whether replication is using GTIDs or not. |
| SSL_ALLOWED | enum('YES', 'NO', 'IGNORED') | NO | Whether SSL is allowed for the replica connection. |
| SSL_CA_FILE | varchar(512) | NO | Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS. |
| SSL_CA_PATH | varchar(512) | NO | Path to a directory that contains one or more PEM files that contain X509 certificates for a trusted Certificate Authority (CA) to use for TLS. |
| SSL_CERTIFICATE | varchar(512) | NO | Path to the certificate used to authenticate the master. |
| SSL_CIPHER | varchar(512) | NO | Which cipher is used for encription. |
| SSL_KEY | varchar(512) | NO | Path to the private key used for TLS. |
| SSL_VERIFY_SERVER_CERTIFICATE | enum('YES','NO') | NO | Whether the server certificate is verified as part of the SSL connection. |
| SSL_CRL_FILE | varchar(255) | NO | Path to the PEM file containing one or more revoked X.509 certificates. |
| SSL_CRL_PATH | varchar(255) | NO | PATH to a folder containing PEM files containing one or more revoked X.509 certificates. |
| CONNECTION_RETRY_INTERVAL | int(11) | NO | The number of seconds between connect retries. |
| CONNECTION_RETRY_COUNT | bigint(20) unsigned | NO | The number of times the replica can attempt to reconnect to the source in the event of a lost connection. |
| HEARTBEAT_INTERVAL | double(10,3) unsigned | NO | Number of seconds after which a heartbeat will be sent. |
| IGNORE_SERVER_IDS | longtext | NO | Binary log events from servers (ids) to ignore. |
| REPL_DO_DOMAIN_IDS | longtext | NO | Only apply binary logs from these domain ids. |
| REPL_IGNORE_DOMAIN_IDS | longtext | NO | Binary log events from domains to ignore. |
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
