当前位置: 代码迷 >> 综合 >> replication_applier_configuration、replication_connection_configuration和replication_connection_status
  详细解决方案

replication_applier_configuration、replication_connection_configuration和replication_connection_status

热度:1   发布时间:2024-01-18 06:39:48.0

        上篇我们介绍了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:组内最后异常的时间