The CREATE DB_DISCOVERY TYPE
syntax is used to create a database discovery type rule.
CreateDatabaseDiscoveryType ::=
'CREATE' 'DB_DISCOVERY' 'TYPE' databaseDiscoveryTypeDefinition ( ',' databaseDiscoveryTypeDefinition )*
databaseDiscoveryTypeDefinition ::=
discoveryTypeName '(' 'TYPE' '(' 'NAME' '=' typeName ( ',' 'PROPERTIES' '(' 'key' '=' 'value' ( ',' 'key' '=' 'value' )* ')' )? ')' ')'
discoveryTypeName ::=
identifier
typeName ::=
string
discoveryType
specifies the database discovery service type, ShardingSphere
has built-in support for MySQL.MGR
.discoveryType
CREATE DB_DISCOVERY TYPE db_discovery_group_1_mgr(
TYPE(NAME='MySQL.MGR',PROPERTIES('group-name'='92504d5b-6dec'))
);
CREATE
, DB_DISCOVERY
, TYPE
, NAME
, PROPERTIES