SHOW DB_DISCOVERY RULES [FROM schemaName]
SHOW DB_DISCOVERY TYPES [FROM schemaName]
SHOW DB_DISCOVERY HEARTBEATS [FROM schemaName]
| Column | Description |
|---|---|
| group_name | Rule name |
| data_source_names | Data source name list |
| primary_data_source_name | Primary data source name |
| discovery_type | Database discovery service type |
| discovery_heartbeat | Database discovery service heartbeat |
| Column | Description |
|---|---|
| name | Type name |
| type | Type category |
| props | Type properties |
| Column | Description |
|---|---|
| name | Heartbeat name |
| props | Heartbeat properties |
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=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 | 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)