replication_connection_configuration

This page is part of MariaDB's Documentation.

The parent of this page is: Performance Schema for MariaDB Enterprise Server

Topics on this page:

Overview
USAGE
DETAILS
- SYNONYMS
- SCHEMA
- PARAMETERS
- SKYSQL
- PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
RELATED TOPICS
EXTERNAL REFERENCES

Overview

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:: A description for this Performance-schema Table has not yet been added to this Documentation.

In 10.6 ES, 10.5 ES:: A description for this Performance-schema Table has not yet been added to this Documentation.

In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:: Not present

In 10.4 ES:: Not present

USAGE

DETAILS

SYNONYMS

SCHEMA

CREATE TABLE `replication_connection_configuration` (
  `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel used.',
  `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The host name of the source that the replica is connected to.',
  `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.',
  `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.',
  `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL COMMENT 'Whether replication is using GTIDs or not',
  `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Whether SSL is allowed for the replica connection.',
  `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.',
  `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.',
  `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.',
  `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.',
  `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Whether the server certificate is verified as part of the SSL connection',
  `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.',
  `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.',
  `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.',
  `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent.',
  `IGNORE_SERVER_IDS` longtext NOT NULL COMMENT 'Binary log events from servers (ids) to ignore.',
  `REPL_DO_DOMAIN_IDS` longtext NOT NULL COMMENT 'Only apply binary logs from these domain ids.',
  `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from domains to ignore.'
)

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Schema changed in MariaDB Enterprise Server 10.6.4-1: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0mb3 COLLATE utf8mb3_bin NOT NULL, `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255)IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL ) Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel used.', `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT 'The host name of the source that the replica is connected to.', `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.', `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.', `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL COMMENT 'Whether replication is using GTIDs or not', `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Whether SSL is allowed for the replica connection.', `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.', `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.', `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.', `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.', `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Whether the server certificate is verified as part of the SSL connection', `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.', `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.', `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.', `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from servers (ids) to ignore.', `REPL_DO_DOMAIN_IDS` longtext NOT NULL COMMENT 'Only apply binary logs from these domain ids.', `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from domains to ignore.' )
10.6 Community	Schema changed in MariaDB Community Server 10.6.0: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255)IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL ) Schema changed in MariaDB Community Server 10.6.1: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` varchar(256) NOT NULL, `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8_binutf8mb3_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8_binutf8mb3_bin NOT NULL, `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL ) Schema changed in MariaDB Community Server 10.6.5: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel used.', `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT 'The host name of the source that the replica is connected to.', `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.', `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.', `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL COMMENT 'Whether replication is using GTIDs or not', `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Whether SSL is allowed for the replica connection.', `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.', `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.', `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.', `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.', `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Whether the server certificate is verified as part of the SSL connection', `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.', `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.', `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.', `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from servers (ids) to ignore.', `REPL_DO_DOMAIN_IDS` longtext NOT NULL COMMENT 'Only apply binary logs from these domain ids.', `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from domains to ignore.' )
10.5 Enterprise	Added in MariaDB Enterprise Server 10.5.3-1. Schema changed in MariaDB Enterprise Server 10.5.6-4: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.8-5: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.13-9: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'The replication channel used.', `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT 'The host name of the source that the replica is connected to.', `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.', `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.', `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The network interface that the replica is bound to, if any.', `AUTO_POSITION` enum('1','0') NOT NULL COMMENT '1 if GTID auto-positioning is in use; otherwise 0.', `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Wether SSL is allowed for the replica connection.', `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.', `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.', `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.', `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.', `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Wether the server certificate is verified as part of the SSL connection', `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.', `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.', `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.', `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL COMMENT 'Not implemented, always blank.' )
10.5 Community	Added in MariaDB Community Server 10.5.2. Schema changed in MariaDB Community Server 10.5.13: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'The replication channel used.', `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT 'The host name of the source that the replica is connected to.', `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.', `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.', `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The network interface that the replica is bound to, if any.', `AUTO_POSITION` enum('1','0') NOT NULL COMMENT '1 if GTID auto-positioning is in use; otherwise 0.', `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Wether SSL is allowed for the replica connection.', `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.', `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.', `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.', `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.', `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Wether the server certificate is verified as part of the SSL connection', `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.', `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.', `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.', `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL COMMENT 'Not implemented, always blank.' )
10.4 Enterprise	Not present.
10.4 Community	Not present.
10.3 Enterprise	Not present.
10.3 Community	Not present.
10.2 Enterprise	Not present.
10.2 Community	Not present.

Release Series	History
10.6 Enterprise	Schema changed in MariaDB Enterprise Server 10.6.4-1: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64varchar(256) NOT NULL, `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0mb3 COLLATE utf8mb3_bin NOT NULL, `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255)IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL ) Schema changed in MariaDB Enterprise Server 10.6.5-2: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` varchar(256) NOT NULL COMMENT 'The replication channel used.', `HOST` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL, `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT 'The host name of the source that the replica is connected to.', `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.', `USER` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.', `USING_GTID` enum('NO','CURRENT_POS','SLAVE_POS') NOT NULL COMMENT 'Whether replication is using GTIDs or not', `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Whether SSL is allowed for the replica connection.', `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.', `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.', `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.', `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.', `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Whether the server certificate is verified as part of the SSL connection', `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.', `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.', `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.', `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `IGNORE_SERVER_IDS` longtext NOT NULL, `REPL_DO_DOMAIN_IDS` longtext NOT NULL, `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from servers (ids) to ignore.', `REPL_DO_DOMAIN_IDS` longtext NOT NULL COMMENT 'Only apply binary logs from these domain ids.', `REPL_IGNORE_DOMAIN_IDS` longtext NOT NULL COMMENT 'Binary log events from domains to ignore.' )
10.5 Enterprise	Added in MariaDB Enterprise Server 10.5.3-1. Schema changed in MariaDB Enterprise Server 10.5.6-4: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.8-5: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) CHARACTER SET utf8 NOT NULL, `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL, `HEARTBEAT_INTERVAL` double(10,3) unsigned NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL ) Schema changed in MariaDB Enterprise Server 10.5.13-9: ... CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) NOT NULL COMMENT 'The replication channel used.', `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PORT` int(11) NOT NULL, `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `AUTO_POSITION` enum('1','0') NOT NULL, `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL, `SSL_CA_FILE` varchar(512) NOT NULL, `SSL_CA_PATH` varchar(512) NOT NULL, `SSL_CERTIFICATE` varchar(512) NOT NULL, `SSL_CIPHER` varchar(512) NOT NULL, `SSL_KEY` varchar(512) NOT NULL, `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL, `SSL_CRL_FILE` varchar(255) NOT NULL, `SSL_CRL_PATH` varchar(255) NOT NULL, `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL, `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT 'The host name of the source that the replica is connected to.', `PORT` int(11) NOT NULL COMMENT 'The port used to connect to the source.', `USER` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The user name of the replication user account used to connect to the source.', `NETWORK_INTERFACE` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The network interface that the replica is bound to, if any.', `AUTO_POSITION` enum('1','0') NOT NULL COMMENT '1 if GTID auto-positioning is in use; otherwise 0.', `SSL_ALLOWED` enum('YES','NO','IGNORED') NOT NULL COMMENT 'Wether SSL is allowed for the replica connection.', `SSL_CA_FILE` varchar(512) NOT NULL COMMENT 'Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.', `SSL_CA_PATH` varchar(512) NOT NULL COMMENT '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) NOT NULL COMMENT 'Path to the certificate used to authenticate the master.', `SSL_CIPHER` varchar(512) NOT NULL COMMENT 'Which cipher is used for encription.', `SSL_KEY` varchar(512) NOT NULL COMMENT 'Path to the private key used for TLS.', `SSL_VERIFY_SERVER_CERTIFICATE` enum('YES','NO') NOT NULL COMMENT 'Wether the server certificate is verified as part of the SSL connection', `SSL_CRL_FILE` varchar(255) NOT NULL COMMENT 'Path to the PEM file containing one or more revoked X.509 certificates.', `SSL_CRL_PATH` varchar(255) NOT NULL COMMENT 'PATH to a folder containing PEM files containing one or more revoked X.509 certificates.', `CONNECTION_RETRY_INTERVAL` int(11) NOT NULL COMMENT 'The number of seconds between connect retries.', `CONNECTION_RETRY_COUNT` bigint(20) unsigned NOT NULL COMMENT '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 NOT NULL COMMENT 'Number of seconds after which a heartbeat will be sent .', `TLS_VERSION` varchar(255) NOT NULL COMMENT 'Not implemented, always blank.' )
10.4 Enterprise	Not present.

replication_connection_configuration

Overview

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

RELATED TOPICS

EXTERNAL REFERENCES