RaigorJiang commented on a change in pull request #12794:
URL: https://github.com/apache/shardingsphere/pull/12794#discussion_r718116839
##########
File path: docs/document/content/features/dist-sql/usage/db-discovery.cn.md
##########
@@ -0,0 +1,99 @@
++++
+title = "数据库发现"
+weight = 5
++++
+
+## 使用实战
+
+### 前置工作
+
+1. 启动MySQL服务
+2. 创建MySQL数据库(参考ShardingProxy数据源配置规则)
+3. 为ShardingProxy创建一个拥有创建权限的角色或者用户
+4. 启动Zookeeper服务 (为了持久化配置)
+
+### 启动ShardingProxy
+
+1. 添加 `mode` 和 `authentication` 配置参数到 `server.yaml` (请参考相关example案例)
+2. 启动 ShardingProxy ([相关介绍](/cn/quick-start/shardingsphere-proxy-quick-start/))
+
+### 创建分布式数据库和分片表
+
+1. 连接到ShardingProxy
+2. 创建分布式数据库
+
+```SQL
+CREATE DATABASE discovery_db;
+```
+
+3. 使用新创建的数据库
+
+```SQL
+USE discovery_db;
+```
+
+4. 配置数据源信息
+
+```SQL
+ADD RESOURCE ds_0 (
+HOST=127.0.0.1,
+PORT=3306,
+DB=ds_0,
+USER=root,
+PASSWORD=root
+),ds_1 (
+HOST=127.0.0.1,
+PORT=3306,
+DB=ds_1,
+USER=root,
+PASSWORD=root
+),ds_2 (
+HOST=127.0.0.1,
+PORT=3306,
+DB=ds_2,
+USER=root,
+PASSWORD=root
+);
+```
+
+5. 创建数据库发现规则
+
+```SQL
+CREATE DB_DISCOVERY RULE group_0 (
+RESOURCES(ds_0,ds_1),
+TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron=''))
+);
+```
+
+6. 修改数据库发现规则
+
+```SQL
+ALTER DB_DISCOVERY RULE group_0 (
+RESOURCES(ds_0,ds_1,ds_2),
+TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec' ,keepAliveCron=''))
+);
+```
+
+7. 删除数据库发现规则
+
+```SQL
+DROP DB_DISCOVERY RULE group_0;
+```
+
+8. 删除数据源
+
+```SQL
+DROP RESOURCE ds_0,ds_1,ds_2;
+```
+
+9. 删除分布式数据库
+
+```SQL
+DROP DATABASE discovery_db;
+```
+
+### 注意事项
+
+1. 当前, `DROP DB` 只会移除`逻辑的分布式数据库`，不会删除用户真实的数据库。
Review comment:
DROP DATABASE, CREATE DATABASE
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
