DB Discovery

Syntax

SHOW DB_DISCOVERY RULES [FROM schemaName]

Return Value Description

Column Description
name Rule name
data_source_names Data source name list
primary_data_source_name Primary data source name
discover_type Database discovery service type
discover_props Database discovery service parameters

Example

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