####################################### 8.0 ####################################### rm -rf 99989/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/99989 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/99989 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/99989/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1 & ######### bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.20 MySQL Community Server - GPL Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select * from performance_schema.replication_connection_configuration; Empty set (0.00 sec) mysql> select * from performance_schema.replication_connection_status; Empty set (0.00 sec) mysql> change master to master_host='test' for channel '12345678901234567890123456789012345678901234567890'; Query OK, 0 rows affected (0.02 sec) mysql> change master to master_host='asdf' for channel '12345678901234567890'; Query OK, 0 rows affected (0.02 sec) mysql> select * from performance_schema.replication_connection_configuration\G *************************** 1. row *************************** CHANNEL_NAME: 12345678901234567890123456789012345678901234567890 HOST: test PORT: 3306 USER: NETWORK_INTERFACE: AUTO_POSITION: 0 SSL_ALLOWED: NO SSL_CA_FILE: SSL_CA_PATH: SSL_CERTIFICATE: SSL_CIPHER: SSL_KEY: SSL_VERIFY_SERVER_CERTIFICATE: NO SSL_CRL_FILE: SSL_CRL_PATH: CONNECTION_RETRY_INTERVAL: 60 CONNECTION_RETRY_COUNT: 86400 HEARTBEAT_INTERVAL: 30.000 TLS_VERSION: PUBLIC_KEY_PATH: GET_PUBLIC_KEY: NO NETWORK_NAMESPACE: COMPRESSION_ALGORITHM: uncompressed ZSTD_COMPRESSION_LEVEL: 3 TLS_CIPHERSUITES: NULL *************************** 2. row *************************** CHANNEL_NAME: 12345678901234567890 HOST: asdf PORT: 3306 USER: NETWORK_INTERFACE: AUTO_POSITION: 0 SSL_ALLOWED: NO SSL_CA_FILE: SSL_CA_PATH: SSL_CERTIFICATE: SSL_CIPHER: SSL_KEY: SSL_VERIFY_SERVER_CERTIFICATE: NO SSL_CRL_FILE: SSL_CRL_PATH: CONNECTION_RETRY_INTERVAL: 60 CONNECTION_RETRY_COUNT: 86400 HEARTBEAT_INTERVAL: 30.000 TLS_VERSION: PUBLIC_KEY_PATH: GET_PUBLIC_KEY: NO NETWORK_NAMESPACE: COMPRESSION_ALGORITHM: uncompressed ZSTD_COMPRESSION_LEVEL: 3 TLS_CIPHERSUITES: NULL 2 rows in set (0.01 sec) mysql> select * from performance_schema.replication_connection_status\G *************************** 1. row *************************** CHANNEL_NAME: 12345678901234567890123456789012345678901234567890 GROUP_NAME: SOURCE_UUID: THREAD_ID: NULL SERVICE_STATE: OFF COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00.000000 RECEIVED_TRANSACTION_SET: LAST_ERROR_NUMBER: 0 LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION: LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP: 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION: QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP: 0000-00-00 00:00:00.000000 *************************** 2. row *************************** CHANNEL_NAME: 12345678901234567890 GROUP_NAME: SOURCE_UUID: THREAD_ID: NULL SERVICE_STATE: OFF COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00.000000 RECEIVED_TRANSACTION_SET: LAST_ERROR_NUMBER: 0 LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION: LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP: 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP: 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION: QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP: 0000-00-00 00:00:00.000000 2 rows in set (0.00 sec) mysql> create database test; Query OK, 1 row affected (0.01 sec) mysql> use test; Database changed mysql> CREATE TABLE `replication_connection_configuration` ( -> `CHANNEL_NAME` char(64) NOT NULL, -> `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, -> `PORT` int NOT NULL, -> `USER` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, -> `NETWORK_INTERFACE` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_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_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 NOT NULL, `CONNECTION_RETRY_ -> COUNT` `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 NOT NULL, -> `CONNECTION_RETRY_COUNT` bigint 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, -> `PUBLIC_KEY_PATH` varchar(512) NOT NULL, -> `GET_PUBLIC_KEY` enum('YES','NO') NOT NULL, -> `NETWORK_NAMESPACE` varchar(64) NOT NULL, -> `COMPRESSION_ALGORITHM` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Compression algorithm used for data transfer between master and slave.', -> `ZSTD_COMPRESSION_LEVEL` int NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.', -> `TLS_CIPHERSUITES` text CHARACTER SET utf8 COLLATE utf8_bin, -> PRIMARY KEY (`CHANNEL_NAME`) -> ) ENGINE=innodb DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; Query OK, 0 rows affected, 4 warnings (0.01 sec) mysql> show warnings; +---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Warning | 1681 | Specifying number of digits for floating point data types is deprecated and will be removed in a future release. | | Warning | 1681 | UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. | | Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. | | Warning | 3778 | 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. | +---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> CREATE TABLE `replication_connection_status` ( -> `CHANNEL_NAME` char(64) NOT NULL, -> `GROUP_NAME` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, -> `SOURCE_UUID` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, -> `THREAD_ID` bigint unsigned DEFAULT NULL, -> `SERVICE_STATE` enum('ON','OFF','CONNECTING') NOT NULL, -> `COUNT_RECEIVED_HEARTBEATS` bigint unsigned NOT NULL DEFAULT '0', -> `LAST_HEARTBEAT_TIMESTAMP` timestamp(6) NOT NULL COMMENT 'Shows when the most recent heartbeat signal was received.', -> `RECEIVED_TRANSACTION_SET` longtext NOT NULL, -> `LAST_ERROR_NUMBER` int NOT NULL, -> `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, -> `LAST_ERROR_TIMESTAMP` timestamp(6) NOT NULL, -> `LAST_QUEUED_TRANSACTION` char(57) DEFAULT NULL, -> `LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP` timestamp(6) NOT NULL, -> `LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP` timestamp(6) NOT NULL, -> `LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP` timestamp(6) NOT NULL, -> `LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP` timestamp(6) NOT NULL, -> `QUEUEING_TRANSACTION` char(57) DEFAULT NULL, -> `QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP` timestamp(6) NOT NULL, -> `QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP` timestamp(6) NOT NULL, -> `QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP` timestamp(6) NOT NULL, -> PRIMARY KEY (`CHANNEL_NAME`), -> KEY `THREAD_ID` (`THREAD_ID`) -> ) ENGINE=innodb DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; Query OK, 0 rows affected (0.01 sec) mysql> insert into replication_connection_configuration select * from performance_schema.replication_connection_configuration; Query OK, 2 rows affected (0.02 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> insert into replication_connection_status select * from performance_schema.replication_connection_status; ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00.000000' for column 'LAST_HEARTBEAT_TIMESTAMP' at row 1 mysql> mysql> set sql_mode=''; Query OK, 0 rows affected (0.00 sec) mysql> insert into replication_connection_status select * from performance_schema.replication_connection_status; Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcc.channel_name=rcs.channel_name ; +----------------------------------------------------+----------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | NULL | NULL | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcs.channel_name<=>rcc.channel_name; +----------------------------------------------------+----------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | NULL | NULL | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on binary rcc.channel_name=rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcc.channel_name like rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcs.channel_name<=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890 | 0 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcs.channel_name>=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890123456789012345678901234567890 | 0 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcc.channel_name=rcs.channel_name ; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890 | 12345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.01 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcs.channel_name<=>rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890 | 12345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on binary rcc.channel_name=rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890 | 12345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.01 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcc.channel_name like rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890 | 12345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcs.channel_name<=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890 | 12345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890 | 0 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcs.channel_name>=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890 | 12345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890123456789012345678901234567890 | 0 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) ####################################### 5.7 ####################################### - tables using same structure as 5.7 perf schema to avoid column count mismatch (ERROR 1136 (21S01)) had I used test schema tables from the report which is 8.x compatible rm -rf 99989/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/99989 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/99989 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/99989/log.err --log-error-verbosity=3 --secure-file-priv="" --skip-name-resolve --performance-schema=ON --log-bin --server-id=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE 2>&1 & - create database test; use test; CREATE TABLE `replication_connection_configuration` ( `CHANNEL_NAME` char(64) 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 ) ENGINE=INNODB DEFAULT CHARSET=utf8; CREATE TABLE `replication_connection_status` ( `CHANNEL_NAME` char(64) NOT NULL, `GROUP_NAME` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `SOURCE_UUID` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `THREAD_ID` bigint(20) unsigned DEFAULT NULL, `SERVICE_STATE` enum('ON','OFF','CONNECTING') NOT NULL, `COUNT_RECEIVED_HEARTBEATS` bigint(20) unsigned NOT NULL DEFAULT '0', `LAST_HEARTBEAT_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Shows when the most recent heartbeat signal was received.', `RECEIVED_TRANSACTION_SET` longtext NOT NULL, `LAST_ERROR_NUMBER` int(11) NOT NULL, `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=INNODB DEFAULT CHARSET=utf8; mysql> CREATE TABLE `replication_connection_configuration` ( -> `CHANNEL_NAME` char(64) 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 -> ) ENGINE=INNODB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE `replication_connection_status` ( -> `CHANNEL_NAME` char(64) NOT NULL, -> `GROUP_NAME` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, -> `SOURCE_UUID` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, -> `THREAD_ID` bigint(20) unsigned DEFAULT NULL, -> `SERVICE_STATE` enum('ON','OFF','CONNECTING') NOT NULL, -> `COUNT_RECEIVED_HEARTBEATS` bigint(20) unsigned NOT NULL DEFAULT '0', -> `LAST_HEARTBEAT_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Shows when the most recent heartbeat signal was received.', -> `RECEIVED_TRANSACTION_SET` longtext NOT NULL, -> `LAST_ERROR_NUMBER` int(11) NOT NULL, -> `LAST_ERROR_MESSAGE` varchar(1024) NOT NULL, -> `LAST_ERROR_TIMESTAMP` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' -> ) ENGINE=INNODB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.00 sec) mysql> insert into replication_connection_configuration select * from performance_schema.replication_connection_configuration; Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> insert into replication_connection_status select * from performance_schema.replication_connection_status; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcc.channel_name=rcs.channel_name ; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcs.channel_name<=>rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on binary rcc.channel_name=rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcc.channel_name like rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcs.channel_name<=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890 | 0 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from performance_schema.replication_connection_configuration rcc -> left join performance_schema.replication_connection_status rcs on rcs.channel_name>=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890123456789012345678901234567890 | 0 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcc.channel_name=rcs.channel_name ; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.01 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcs.channel_name<=>rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on binary rcc.channel_name=rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcc.channel_name like rcs.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 2 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcs.channel_name<=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890123456789012345678901234567890 | 12345678901234567890 | 0 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec) mysql> mysql> select rcc.channel_name,rcs.channel_name,rcc.channel_name=rcs.channel_name -> from replication_connection_configuration rcc -> left join replication_connection_status rcs on rcs.channel_name>=rcc.channel_name; +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | channel_name | channel_name | rcc.channel_name=rcs.channel_name | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ | 12345678901234567890123456789012345678901234567890 | 12345678901234567890123456789012345678901234567890 | 1 | | 12345678901234567890 | 12345678901234567890123456789012345678901234567890 | 0 | | 12345678901234567890 | 12345678901234567890 | 1 | +----------------------------------------------------+----------------------------------------------------+-----------------------------------+ 3 rows in set (0.00 sec)