CREATE DB_DISCOVERY RULE

Description

The CREATE DB_DISCOVERY RULE syntax is used to create a database discovery rule.

Syntax

CreateDatabaseDiscoveryRule ::=
  'CREATE' 'DB_DISCOVERY' 'RULE' databaseDiscoveryDefinition ( ',' databaseDiscoveryDefinition)*
databaseDiscoveryDefinition ::=
    ruleName '(' 'STORAGE_UNITS' '(' storageUnitName ( ',' storageUnitName )* ')' ',' 'TYPE' '(' 'NAME' '=' typeName ( ',' 'PROPERTIES' 'key' '=' 'value' ( ',' 'key' '=' 'value' )* )? ',' 'HEARTBEAT' '(' 'key' '=' 'value' ( ',' 'key' '=' 'value' )* ')' ')' 
ruleName ::=
  identifier
storageUnitName ::=
  identifier
typeName ::=
  identifier
discoveryHeartbeatName ::=
  identifier

Supplement

• discoveryType specifies the database discovery service type, ShardingSphere has built-in support for MySQL.MGR;
• Duplicate ruleName will not be created.

Example

• Create database discovery rule

CREATE
DB_DISCOVERY RULE db_discovery_group_0 (
    STORAGE_UNITS(su_0, su_1, su_2),
    TYPE(NAME='MySQL.MGR',PROPERTIES('group-name'='92504d5b-6dec')),
    HEARTBEAT(PROPERTIES('keep-alive-cron'='0/5 * * * * ?'))
);

Reserved word

CREATE, DB_DISCOVERY, RULE, STORAGE_UNITS, TYPE, NAME, PROPERTIES, HEARTBEAT

Related links

• Reserved word