tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_RGS

META_CLUSTER_RGS

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-02-10 11:06:29

Function

INFORMATION_SCHEMA.META_CLUSTER_RGS is used to store and display metadata related to Replication Groups (RG) within the instance.

Field Description

Field Name
Type
Description
rep_group_id
bigint unsigned
RG ID.
data_space_type
varchar(64)
Type of data space.
DATA_SPACE_TYPE_SYSTEM: system space.
DATA_SPACE_TYPE_USER: user space.
rep_group_state
varchar(64)
RG status.
meta_version
bigint
Metadata Version.
member_version
bigint
Membership change version.
key_range_version
bigint
version of key range.
quorum
int unsigned
Legal Quorum.
member_node_names
varchar(320)
Member list.
leader_node_name
varchar(320)
Leader member.
last_leader_report_time
varchar(64)
Last reported time of the heartbeat.
create_time
varchar(64)
creation time of RG.
parent_rep_group_id
bigint unsigned
If a split occurs, then it reflects the ID of the parent RG; otherwise the value is 0.
rep_group_stats_approximate_size
bigint unsigned
Approximate data size of the RG Leader in bytes.
rep_group_stats_approximate_keys
bigint unsigned
Approximate number of keys in the RG Leader.
rep_group_log_info_current_term
bigint unsigned
Current Leader term.
rep_group_log_info_committed_index
bigint unsigned
The index of the committed log.
rep_group_log_info_consecutive_applied_index
bigint unsigned
Applied log index.
rep_group_log_info_last_snapshot_index
bigint unsigned
The log index of the last snapshot taken.
rep_group_log_info_first_index
bigint unsigned
The starting log index of the Raft Log retained in memory, indicating that logs before this have been purged.
rep_group_log_info_last_index
bigint unsigned
The last log index of the Raft Log retained in memory.
rep_group_log_info_disk_index
bigint unsigned
The persisted log index of the Raft Log.
rep_group_log_info_applied_index
bigint unsigned
Applied index of the Raft Log.
rep_group_log_info_raft_log_sync_delay_seconds
bigint unsigned
Delay of replica log synchronization.

property
varchar(64)
RG attributes:
RG_PROPERTY_DEFAULT: ordinary RG.
RG_PROPERTY_BROADCAST: broadcast RG.
RG_PROPERTY_SYNC: synchronous RG.
RG_PROPERTY_BROADCAST_SYNC: broadcast synchronous RG.
witness_quorum
int unsigned
witness Legal Quorum.
witnesses
longtext
witness member.

Examples

tdsql>SELECT * FROM information_schema.meta_cluster_rgs\\G;
*************************** 1. row ***************************
                                  rep_group_id: 1792
                               data_space_type: DATA_SPACE_TYPE_SYSTEM
                               rep_group_state: RG_STATE_L_WORKING
                                  meta_version: 36
                                member_version: 0
                             key_range_version: 36
                                        quorum: 3
                             member_node_names: [node-tdsql3-86ea1ffe-001, node-tdsql3-86ea1ffe-002, node-tdsql3-86ea1ffe-003]
                              leader_node_name: node-tdsql3-86ea1ffe-002
                       last_leader_report_time: 2024-08-19 16:31:47.866168
                                   create_time: 2024-08-19 14:56:47.692831
                           parent_rep_group_id: 0
              rep_group_stats_approximate_size: 9725997
              rep_group_stats_approximate_keys: 3836
               rep_group_log_info_current_term: 9
            rep_group_log_info_committed_index: 6783
  rep_group_log_info_consecutive_applied_index: 6783
        rep_group_log_info_last_snapshot_index: 6727
                rep_group_log_info_first_index: 2
                 rep_group_log_info_last_index: 6783
                 rep_group_log_info_disk_index: 6783
              rep_group_log_info_applied_index: 6783
rep_group_log_info_raft_log_sync_delay_seconds: 11
                                      property: RG_PROPERTY_DEFAULT
                                witness_quorum: 0
                                     witnesses: []
*************************** 2. row ***************************
                                  rep_group_id: 1281
                               data_space_type: DATA_SPACE_TYPE_USER
                               rep_group_state: RG_STATE_L_WORKING
                                  meta_version: 3
                                member_version: 0
                             key_range_version: 3
                                        quorum: 3
                             member_node_names: [node-tdsql3-86ea1ffe-001, node-tdsql3-86ea1ffe-002, node-tdsql3-86ea1ffe-003]
                              leader_node_name: node-tdsql3-86ea1ffe-003
                       last_leader_report_time: 2024-08-19 16:31:49.145344
                                   create_time: 2024-08-19 14:56:47.817777
                           parent_rep_group_id: 0
              rep_group_stats_approximate_size: 3070
              rep_group_stats_approximate_keys: 27
               rep_group_log_info_current_term: 3
            rep_group_log_info_committed_index: 864
  rep_group_log_info_consecutive_applied_index: 864
        rep_group_log_info_last_snapshot_index: 831
                rep_group_log_info_first_index: 2
                 rep_group_log_info_last_index: 864
                 rep_group_log_info_disk_index: 864
              rep_group_log_info_applied_index: 864
rep_group_log_info_raft_log_sync_delay_seconds: 18446744073709551615
                                      property: RG_PROPERTY_DEFAULT
                                witness_quorum: 0
                                     witnesses: []

2 rows in set (0.01 sec)
Anterior: META_CLUSTER_REPLICASPróximo: META_CLUSTER_SCHEDULE_CONFIGS

Ajuda e Suporte

Esta página foi útil?

comentários