数据库发现
定义
CREATE DB_DISCOVERY RULE databaseDiscoveryRuleDefinition [, databaseDiscoveryRuleDefinition] ...
ALTER DB_DISCOVERY RULE databaseDiscoveryRuleDefinition [, databaseDiscoveryRuleDefinition] ...
DROP DB_DISCOVERY RULE ruleName [, ruleName] ...
databaseDiscoveryRuleDefinition:
ruleName(resources, discoveryTypeDefinition)
resources:
RESOURCES(resourceName [, resourceName] ...)
discoveryTypeDefinition:
TYPE(NAME=discoveryType [, PROPERTIES([algorithmProperties] )] )
algorithmProperties:
algorithmProperty [, algorithmProperty] ...
algorithmProperty:
key=value
discoveryType
指定数据库发现服务类型,ShardingSphere
内置支持 MGR
重复的 ruleName
将无法被创建
示例
CREATE DB_DISCOVERY RULE ha_group_0 (
RESOURCES(resource_0,resource_1),
TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron=''))
);
ALTER DB_DISCOVERY RULE ha_group_0 (
RESOURCES(resource_0,resource_1,resource_2),
TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec' ,keepAliveCron=''))
);
DROP DB_DISCOVERY RULE ha_group_0;
文章列表
- Apache ShardingSphere-读写分离
- Apache ShardingSphere-第三方组件依赖
- Apache ShardingSphere-注册中心
- Apache ShardingSphere-数据源资源
- Apache ShardingSphere-数据库发现
- Apache ShardingSphere-数据加密
- Apache ShardingSphere-数据分片
- Apache ShardingSphere-应用性能监控集成
- Apache ShardingSphere-变更历史
- Apache ShardingSphere-SCTL
- Apache ShardingSphere-Agent集成
- Apache ShardingSphere-3.8. Dist SQL
- Apache ShardingSphere-3.7.2. 实现原理
- Apache ShardingSphere-3.7.1. 核心概念
- Apache ShardingSphere-3.7. 影子库压测
- Apache ShardingSphere-3.6.3. 使用规范
- Apache ShardingSphere-3.6.2. 实现原理
- Apache ShardingSphere-3.6. 数据加密
- Apache ShardingSphere-3.5.3. 使用规范
- Apache ShardingSphere-3.5.2. 实现原理
- Apache ShardingSphere-3.5.1. 核心概念
- Apache ShardingSphere-3.5. 弹性伸缩
- Apache ShardingSphere-3.4. 分布式治理
- Apache ShardingSphere-3.3.2. 使用规范
- Apache ShardingSphere-3.3.1. 核心概念
- Apache ShardingSphere-3.3. 读写分离