DB Discovery

    • discoveryType specifies the database discovery service type, ShardingSphere has built-in support for MySQL.MGR
    • Duplicate ruleName will not be created
    • The discoveryType and discoveryHeartbeat being used cannot be deleted

    Example

    1. CREATE DB_DISCOVERY RULE db_discovery_group_0 (
    2. STORAGE_UNITS(ds_0, ds_1, ds_2),
    3. TYPE(NAME='MySQL.MGR',PROPERTIES('group-name'='92504d5b-6dec')),
    4. HEARTBEAT(PROPERTIES('keep-alive-cron'='0/5 * * * * ?'))
    5. );
    8. STORAGE_UNITS(ds_0, ds_1, ds_2),
    9. HEARTBEAT(PROPERTIES('keep-alive-cron'='0/5 * * * * ?'))
    10. );
    12. DROP DB_DISCOVERY RULE db_discovery_group_0;
    14. DROP DB_DISCOVERY TYPE db_discovery_group_0_mgr;