复古 护眼 海天 深邃 暗黑 默认

数据库发现

语法说明

SHOW DB_DISCOVERY RULES [FROM databaseName]

SHOW DB_DISCOVERY TYPES [FROM databaseName]

SHOW DB_DISCOVERY HEARTBEATS [FROM databaseName]

返回值说明

DB Discovery Rule

说明
group_name 规则名称
data_source_names 数据源名称列表
primary_data_source_name 主数据源名称
discovery_type 数据库发现服务类型
discovery_heartbeat 数据库发现服务心跳

DB Discovery Type

说明
name 类型名称
type 类型种类
props 类型参数

DB Discovery Heartbeat

说明
name 心跳名称
props 心跳参数

示例

DB Discovery Rule

mysql> show db_discovery rules;
+----------------------+-------------------+--------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------+
| group_name           | data_source_names | primary_data_source_name | discovery_type                                                                    | discovery_heartbeat                                                          |
+----------------------+-------------------+--------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------+
| db_discovery_group_0 | ds_0,ds_1,ds_2    |        ds_0              | {name=db_discovery_group_0_mgr, type=MySQL.MGR, props={group-name=92504d5b-6dec}} | {name=db_discovery_group_0_heartbeat, props={keep-alive-cron=0/5 * * * * ?}} |
+----------------------+-------------------+--------------------------+-----------------------------------------------------------------------------------+-----------------------------------------------------------------------------+
1 row in set (0.20 sec)

DB Discovery Type

mysql> show db_discovery types;
+--------------------------+------------+----------------------------+
| name                     | type       | props                      |
+--------------------------+------------+----------------------------+
| db_discovery_group_0_mgr | MySQL.MGR  | {group-name=92504d5b-6dec} |
+--------------------------+------------+----------------------------+
1 row in set (0.01 sec)

DB Discovery Heartbeat

mysql> show db_discovery heartbeats;
+--------------------------------+---------------------------------+
| name                           | props                           |
+--------------------------------+---------------------------------+
| db_discovery_group_0_heartbeat | {keep-alive-cron=0/5 * * * * ?} |
+---------------------------------+---------------------------------+
1 row in set (0.01 sec)