上篇我们介绍了group replication架构中,member和状态相关表的含义。本篇我们主要介绍group replication配置、连接配置和状态等信息
1、replication_applier_configuration:group replication同步延迟复制的配置信息
mysql> select * from replication_applier_configuration;
+----------------------------+---------------+
| CHANNEL_NAME | DESIRED_DELAY |
+----------------------------+---------------+
| group_replication_applier | 0 |
| group_replication_recovery | 0 |
+----------------------------+---------------+
2 rows in set (0.00 sec)
channel_name:
group_replication_applier:应用来组组内的事务
group_replication_recovery:用于同分布式恢复阶段相关的复制更改,一般用于成员新加入时的恢复
desired_delay:group replication 通道的延迟时间
2、replication_connection_configuration:group replication 连接配置信息
mysql> select * from replication_connection_configuration\G
*************************** 1. row ***************************CHANNEL_NAME: group_replication_applierHOST: <NULL>PORT: 0USER: testNETWORK_INTERFACE: AUTO_POSITION: 1SSL_ALLOWED: NOSSL_CA_FILE: SSL_CA_PATH: SSL_CERTIFICATE: SSL_CIPHER: SSL_KEY:
SSL_VERIFY_SERVER_CERTIFICATE: NOSSL_CRL_FILE: SSL_CRL_PATH: CONNECTION_RETRY_INTERVAL: 60CONNECTION_RETRY_COUNT: 86400HEARTBEAT_INTERVAL: 30.000TLS_VERSION:
*************************** 2. row ***************************CHANNEL_NAME: group_replication_recoveryHOST: <NULL>PORT: 0USER: replNETWORK_INTERFACE: AUTO_POSITION: 1SSL_ALLOWED: NOSSL_CA_FILE: SSL_CA_PATH: SSL_CERTIFICATE: SSL_CIPHER: SSL_KEY:
SSL_VERIFY_SERVER_CERTIFICATE: NOSSL_CRL_FILE: SSL_CRL_PATH: CONNECTION_RETRY_INTERVAL: 60CONNECTION_RETRY_COUNT: 1HEARTBEAT_INTERVAL: 30.000TLS_VERSION:
2 rows in set (0.00 sec)mysql>
3、replication_connection_status
mysql> select * from replication_connection_status\G
*************************** 1. row ***************************CHANNEL_NAME: group_replication_applierGROUP_NAME: 05153196-c2ab-43ae-b355-b9832eacf0b2SOURCE_UUID: 05153196-c2ab-43ae-b355-b9832eacf0b2THREAD_ID: NULLSERVICE_STATE: ON
COUNT_RECEIVED_HEARTBEATS: 0LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00RECEIVED_TRANSACTION_SET: 05153196-c2ab-43ae-b355-b9832eacf0b2:1-26:1000006-1000008:2000006-2000011LAST_ERROR_NUMBER: 0LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
*************************** 2. row ***************************CHANNEL_NAME: group_replication_recoveryGROUP_NAME: SOURCE_UUID: THREAD_ID: NULLSERVICE_STATE: OFF
COUNT_RECEIVED_HEARTBEATS: 0LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00RECEIVED_TRANSACTION_SET: LAST_ERROR_NUMBER: 0LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
2 rows in set (0.00 sec)
channel_name:group replication 组内通道名称
group_name:group replication 的名称
source_uuid:group replication的源uuid
thread_id:连接group replication的进程id
service_state:通道的状态
count_received_heartbeats:组内通道接收到的心跳信号次数
last_heartbeat_timestamp:最近一次接收到心跳信号的时间
received_transaction_set:组内全局事务id的集合
last_error_number:组内最后异常的编号
last_error_message:组内最后异常的信息
last_error_timestamp:组内最后异常的时间