DB Discovery

Definition

  1. SHOW DB_DISCOVERY RULES [FROM schemaName]

Description

ColumnDescription
nameRule name
data_source_namesData source name list
primary_data_source_namePrimary data source name
discover_typeDatabase discovery service type
discover_propsDatabase discovery service parameters

Example

  1. mysql> show db_discovery rules from database_discovery_db;
  2. +-------+---------------------+--------------------------+---------------+------------------------------------------------------------------------------------------------------------+
  3. | name  | data_source_names   | primary_data_source_name | discover_type | discover_props                                                                                             |
  4. +-------+---------------------+--------------------------+---------------+------------------------------------------------------------------------------------------------------------+
  5. | pr_ds | ds_0, ds_1, ds_2    | ds_0                     | MGR           | keepAliveCron=0/50 * * * * ?, zkServerLists=localhost:2181, groupName=b13df29e-90b6-11e8-8d1b-525400fc3996 |
  6. +-------+---------------------+--------------------------+---------------+------------------------------------------------------------------------------------------------------------+
  7. 1 row in set (0.00 sec)