replication_applier_configuration、replication_connection_configuration和replication_connection_status

最新推荐文章于 2022-04-05 19:43:13 发布

sendqmail

最新推荐文章于 2022-04-05 19:43:13 发布

阅读量245

点赞数

分类专栏： mysql 文章标签： mysql 数据库架构 dba

本文链接：https://blog.csdn.net/sendqmail/article/details/119781440

版权

mysql 专栏收录该内容

20 篇文章 1 订阅

订阅专栏

上篇我们介绍了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_applier
                         HOST: <NULL>
                         PORT: 0
                         USER: test
            NETWORK_INTERFACE: 
                AUTO_POSITION: 1
                  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: 
*************************** 2. row ***************************
                 CHANNEL_NAME: group_replication_recovery
                         HOST: <NULL>
                         PORT: 0
                         USER: repl
            NETWORK_INTERFACE: 
                AUTO_POSITION: 1
                  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: 1
           HEARTBEAT_INTERVAL: 30.000
                  TLS_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_applier
               GROUP_NAME: 05153196-c2ab-43ae-b355-b9832eacf0b2
              SOURCE_UUID: 05153196-c2ab-43ae-b355-b9832eacf0b2
                THREAD_ID: NULL
            SERVICE_STATE: ON
COUNT_RECEIVED_HEARTBEATS: 0
 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
 RECEIVED_TRANSACTION_SET: 05153196-c2ab-43ae-b355-b9832eacf0b2:1-26:1000006-1000008:2000006-2000011
        LAST_ERROR_NUMBER: 0
       LAST_ERROR_MESSAGE: 
     LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
*************************** 2. row ***************************
             CHANNEL_NAME: group_replication_recovery
               GROUP_NAME: 
              SOURCE_UUID: 
                THREAD_ID: NULL
            SERVICE_STATE: OFF
COUNT_RECEIVED_HEARTBEATS: 0
 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
 RECEIVED_TRANSACTION_SET: 
        LAST_ERROR_NUMBER: 0
       LAST_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:组内最后异常的时间