数据库发现 #
语法说明 #
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)