数据库发现
语法说明
CREATE DB_DISCOVERY RULE ruleDefinition [, ruleDefinition] ...
ALTER DB_DISCOVERY RULE ruleDefinition [, ruleDefinition] ...
DROP DB_DISCOVERY RULE ruleName [, ruleName] ...
DROP DB_DISCOVERY TYPE discoveryTypeName [, discoveryTypeName] ...
DROP DB_DISCOVERY HEARTBEAT discoveryHeartbeatName [, discoveryHeartbeatName] ...
ruleDefinition:
ruleName (storageUnits, typeDefinition, heartbeatDefinition)
storageUnits:
STORAGE_UNITS(storageUnitName [, storageUnitName] ...)
typeDefinition:
TYPE(NAME=typeName [, PROPERTIES([properties] )] )
heartbeatDefinition
HEARTBEAT (PROPERTIES (properties))
properties:
property [, property] ...
property:
key=value
参数解释
| 名称 |
数据类型 |
说明 |
| discoveryTypeName |
IDENTIFIER |
数据库发现类型名 |
| ruleName |
IDENTIFIER |
规则名称 |
| discoveryHeartbeatName |
IDENTIFIER |
监听心跳名称 |
| typeName |
STRING |
数据库发现类型，如：MySQL.MGR |
| storageUnitName |
IDENTIFIER |
资源名称 |
注意事项
discoveryType 指定数据库发现服务类型，ShardingSphere 内置支持 MySQL.MGR；- 重复的
ruleName 将无法被创建；
- 正在被使用的
discoveryType 和 discoveryHeartbeat 无法被删除；
- 带有
- 的命名在改动时需要使用 " "；
示例
创建 discoveryRule 时同时创建 discoveryType 和 discoveryHeartbeat
CREATE DB_DISCOVERY RULE db_discovery_group_0 (
STORAGE_UNITS(ds_0, ds_1, ds_2),
TYPE(NAME='MySQL.MGR',PROPERTIES('group-name'='92504d5b-6dec')),
HEARTBEAT(PROPERTIES('keep-alive-cron'='0/5 * * * * ?'))
);
ALTER DB_DISCOVERY RULE db_discovery_group_0 (
STORAGE_UNITS(ds_0, ds_1, ds_2),
TYPE(NAME='MySQL.MGR',PROPERTIES('group-name'='246e9612-aaf1')),
HEARTBEAT(PROPERTIES('keep-alive-cron'='0/5 * * * * ?'))
);
DROP DB_DISCOVERY RULE db_discovery_group_0;
DROP DB_DISCOVERY TYPE db_discovery_group_0_mgr;
DROP DB_DISCOVERY HEARTBEAT db_discovery_group_0_heartbeat;
