DB Discovery

Syntax

  1. SHOW DB_DISCOVERY RULES [FROM databaseName]
  3. SHOW DB_DISCOVERY TYPES [FROM databaseName]
  5. SHOW DB_DISCOVERY HEARTBEATS [FROM databaseName]

Return Value Description

DB Discovery Rule

ColumnDescription
group_nameRule name
data_source_namesData source name list
primary_data_source_namePrimary data source name
discovery_typeDatabase discovery service type
discovery_heartbeatDatabase discovery service heartbeat

DB Discovery Type

ColumnDescription
nameType name
typeType category
propsType properties

DB Discovery Heartbeat

ColumnDescription
nameHeartbeat name
propsHeartbeat properties

Example

DB Discovery Rule

  1. mysql> SHOW DB_DISCOVERY RULES;
  2. +----------------------+-------------------+--------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------+
  3. | group_name           | data_source_names | primary_data_source_name | discovery_type                                                                    | discovery_heartbeat                                                          |
  4. +----------------------+-------------------+--------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------+
  5. | 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 * * * * ?}} |
  6. +----------------------+-------------------+--------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------+
  7. 1 row in set (0.20 sec)

DB Discovery Type

  1. mysql> SHOW DB_DISCOVERY TYPES;
  2. +---------------------------+------------+------------------------------+
  3. | name                      | type       | props                        |
  4. +---------------------------+------------+------------------------------+
  5. | db_discovery_group_0_mgr  | MySQL.MGR  | {group-name=92504d5b-6dec}   |
  6. +---------------------------+------------+------------------------------+
  7. 1 row in set (0.01 sec)

DB Discovery Heartbeat

  1. mysql> SHOW DB_DISCOVERY HEARTBEATS;
  2. +--------------------------------+---------------------------------+
  3. | name                           | props                           |
  4. +--------------------------------+---------------------------------+
  5. | db_discovery_group_0_heartbeat | {keep-alive-cron=0/5 * * * * ?} |
  6. +---------------------------------+---------------------------------+
  7. 1 row in set (0.01 sec)