You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2021/10/23 14:48:43 UTC
[shardingsphere] branch master updated: Move DistSQL usage and
syntax into user-manual of proxy (#13238)
This is an automated email from the ASF dual-hosted git repository.
jianglongtao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 9c43b87 Move DistSQL usage and syntax into user-manual of proxy (#13238)
9c43b87 is described below
commit 9c43b87c4781c76656a0dd7d1f1923807ba32026
Author: Liang Zhang <te...@163.com>
AuthorDate: Sat Oct 23 22:48:10 2021 +0800
Move DistSQL usage and syntax into user-manual of proxy (#13238)
* Update index of DistSQL
* Move DistSQL usage and syntax into user-manual of proxy
* Update docker page
---
docs/document/content/concepts/distsql/_index.cn.md | 11 ++++++-----
docs/document/content/concepts/distsql/_index.en.md | 8 ++++----
docs/document/content/features/shadow/principle.cn.md | 2 ++
.../user-manual/shardingsphere-proxy/docker.cn.md | 2 +-
.../user-manual/shardingsphere-proxy/docker.en.md | 2 +-
.../shardingsphere-proxy/usage/distsql/_index.cn.md | 7 +++++++
.../shardingsphere-proxy/usage/distsql/_index.en.md | 7 +++++++
.../usage}/distsql/syntax/_index.cn.md | 1 -
.../usage}/distsql/syntax/_index.en.md | 1 -
.../usage}/distsql/syntax/ral/_index.cn.md | 1 -
.../usage}/distsql/syntax/ral/_index.en.md | 1 -
.../usage}/distsql/syntax/ral/ral.cn.md | 0
.../usage}/distsql/syntax/ral/ral.en.md | 0
.../usage}/distsql/syntax/rdl/_index.cn.md | 1 -
.../usage}/distsql/syntax/rdl/_index.en.md | 1 -
.../distsql/syntax/rdl/rdl-db-discovery-rule.cn.md | 0
.../distsql/syntax/rdl/rdl-db-discovery-rule.en.md | 0
.../usage}/distsql/syntax/rdl/rdl-encrypt-rule.cn.md | 0
.../usage}/distsql/syntax/rdl/rdl-encrypt-rule.en.md | 0
.../syntax/rdl/rdl-readwrite-splitting-rule.cn.md | 0
.../syntax/rdl/rdl-readwrite-splitting-rule.en.md | 0
.../usage}/distsql/syntax/rdl/rdl-resource.cn.md | 2 +-
.../usage}/distsql/syntax/rdl/rdl-resource.en.md | 2 +-
.../usage}/distsql/syntax/rdl/rdl-shadow-rule.cn.md | 0
.../usage}/distsql/syntax/rdl/rdl-shadow-rule.en.md | 0
.../usage}/distsql/syntax/rdl/rdl-sharding-rule.cn.md | 0
.../usage}/distsql/syntax/rdl/rdl-sharding-rule.en.md | 0
.../usage}/distsql/syntax/rql/_index.cn.md | 1 -
.../usage}/distsql/syntax/rql/_index.en.md | 1 -
.../distsql/syntax/rql/rql-db-discovery-rule.cn.md | 0
.../distsql/syntax/rql/rql-db-discovery-rule.en.md | 0
.../usage}/distsql/syntax/rql/rql-encrypt-rule.cn.md | 0
.../usage}/distsql/syntax/rql/rql-encrypt-rule.en.md | 0
.../syntax/rql/rql-readwrite-splitting-rule.cn.md | 0
.../syntax/rql/rql-readwrite-splitting-rule.en.md | 0
.../usage}/distsql/syntax/rql/rql-resource.cn.md | 0
.../usage}/distsql/syntax/rql/rql-resource.en.md | 0
.../usage}/distsql/syntax/rql/rql-shadow-rule.cn.md | 0
.../usage}/distsql/syntax/rql/rql-shadow-rule.en.md | 0
.../usage}/distsql/syntax/rql/rql-sharding-rule.cn.md | 0
.../usage}/distsql/syntax/rql/rql-sharding-rule.en.md | 0
.../usage}/distsql/syntax/rql/rql-single-table.cn.md | 0
.../usage}/distsql/syntax/rql/rql-single-table.en.md | 0
.../usage}/distsql/usage/_index.cn.md | 1 -
.../usage}/distsql/usage/_index.en.md | 1 -
.../usage}/distsql/usage/db-discovery.cn.md | 16 ++++++++--------
.../usage}/distsql/usage/db-discovery.en.md | 16 ++++++++--------
.../usage}/distsql/usage/encrypt-rule.cn.md | 19 ++++++++++---------
.../usage}/distsql/usage/encrypt-rule.en.md | 18 +++++++++---------
.../distsql/usage/readwirte-splitting-rule.cn.md | 16 ++++++++--------
.../distsql/usage/readwirte-splitting-rule.en.md | 16 ++++++++--------
.../usage}/distsql/usage/shadow-rule.cn.md | 16 ++++++++--------
.../usage}/distsql/usage/shadow-rule.en.md | 16 ++++++++--------
.../usage}/distsql/usage/sharding-rule.cn.md | 18 +++++++++---------
.../usage}/distsql/usage/sharding-rule.en.md | 18 +++++++++---------
55 files changed, 115 insertions(+), 107 deletions(-)
diff --git a/docs/document/content/concepts/distsql/_index.cn.md b/docs/document/content/concepts/distsql/_index.cn.md
index 6f9792e..effb30d 100644
--- a/docs/document/content/concepts/distsql/_index.cn.md
+++ b/docs/document/content/concepts/distsql/_index.cn.md
@@ -11,16 +11,17 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
## 挑战
-灵活的规则配置和资源管控能力是 Apache ShardingSphere 的特点之一，在使用 ShardingSphere-Proxy 时，开发者可以像使用数据库一样操作数据，却需要通过 YAML 文件（或注册中心）配置资源和规则。
-然而，YAML 格式的展现形式，以及注册中心动态修改带来的操作习惯变更，对于运维人员来说并不友好。
+灵活的规则配置和资源管控能力是 Apache ShardingSphere 的特点之一。
+在使用 ShardingSphere-Proxy 时，开发者虽然可以像使用数据库一样操作数据，但却需要通过 YAML 文件（或注册中心）配置资源和规则。
+然而，YAML 格式的展现形式，以及注册中心动态修改带来的操作习惯变更，对于运维工程师并不友好。
-DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
+DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的数据库产品。
-DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
+DistSQL 细分为 RDL、RQL 和 RAL 三种类型。
- RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
- RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - RAL（Resource & Rule Administration Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administration Language）负责 Hint、事务类型切换、分片执行计划查询等管理功能。
## 目标
diff --git a/docs/document/content/concepts/distsql/_index.en.md b/docs/document/content/concepts/distsql/_index.en.md
index 0ac5344..fc10c95 100644
--- a/docs/document/content/concepts/distsql/_index.en.md
+++ b/docs/document/content/concepts/distsql/_index.en.md
@@ -11,16 +11,16 @@ DistSQL（Distributed SQL）is Apache ShardingSphere specific SQL, which provide
## Challenges
-When using ShardingSphere-Proxy, developers can operate data just like using database, but they need to configure resources and rules through YML file (or registry center).
-However, the format of YAML and habits changed by using registry center are not friendly to the operators.
+When using ShardingSphere-Proxy, developers can operate data just like using database, but they need to configure resources and rules through YAML file (or registry center).
+However, the format of YAML and habits changed by using registry center are not friendly to DBA.
-DistSQL enables users to operate Apache ShardingSphere like a database, transforming it from a framework and middleware for developers to an infrastructure product for operators.
+DistSQL enables users to operate Apache ShardingSphere like a database, transforming it from a framework and middleware for developers to a database product for DBAs.
DistSQL is divided into RDL, RQL and RAL.
- RDL (Resource & Rule Definition Language) responsible for the definition of resources and rules;
- RQL (Resource & Rule Query Language) responsible for the query of resources and rules;
- - RAL (Resource & Rule Administration Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+ - RAL (Resource & Rule Administration Language) responsible for the added-on administrator feature of hint, transaction type switch, sharding execute planning and so on.
## Goal
diff --git a/docs/document/content/features/shadow/principle.cn.md b/docs/document/content/features/shadow/principle.cn.md
index 1a2390cf..a5b091a 100644
--- a/docs/document/content/features/shadow/principle.cn.md
+++ b/docs/document/content/features/shadow/principle.cn.md
@@ -98,6 +98,7 @@ props:
* 创建影子库 `ds-shadow`。
* 创建压测相关影子表，影子表结构与生产环境对应表结构必须一致。假设需要在影子库创建 `t_order` 表。创建表语句需要添加 SQL 注释 `/*shadow:true,foo:bar,...*/`。即：
+
```sql
CREATE TABLE t_order (order_id INT(11) primary key, user_id int(11) not null, ...) /*shadow:true,foo:bar,...*/
```
@@ -108,6 +109,7 @@ CREATE TABLE t_order (order_id INT(11) primary key, user_id int(11) not null, ..
1. 列影子算法使用
假设 `t_order` 表中包含字段下单用户ID的 `user_id`。 如果实现的效果，当用户ID为 `0` 的用户创建订单产生的数据。 即：
+
```sql
INSERT INTO t_order (order_id, user_id, ...) VALUES (xxx..., 0, ...)
```
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/docker.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/docker.cn.md
index 6f7aeb6..d9ad459 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/docker.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/docker.cn.md
@@ -1,5 +1,5 @@
+++
-pre = "<b>4.2.3. </b>"
+pre = "<b>5.2.3. </b>"
title = "Docker 镜像"
weight = 3
+++
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/docker.en.md b/docs/document/content/user-manual/shardingsphere-proxy/docker.en.md
index 7492c5e..f86597b 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/docker.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/docker.en.md
@@ -1,5 +1,5 @@
+++
-pre = "<b>4.2.3. </b>"
+pre = "<b>5.2.3. </b>"
title = "Docker Image"
weight = 3
+++
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/_index.cn.md
new file mode 100644
index 0000000..0a3ff5a
--- /dev/null
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/_index.cn.md
@@ -0,0 +1,7 @@
++++
+title = "DistSQL"
+weight = 4
+chapter = true
++++
+
+本章节将介绍 DistSQL 的详细使用。
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/_index.en.md
new file mode 100644
index 0000000..1f252a8
--- /dev/null
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/_index.en.md
@@ -0,0 +1,7 @@
++++
+title = "DistSQL"
+weight = 4
+chapter = true
++++
+
+This chapter introduces how of use DistSQL.
diff --git a/docs/document/content/concepts/distsql/syntax/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/_index.cn.md
similarity index 87%
rename from docs/document/content/concepts/distsql/syntax/_index.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/_index.cn.md
index 948563b..43ccd6f 100644
--- a/docs/document/content/concepts/distsql/syntax/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/_index.cn.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1. </b>"
title = "语法"
weight = 1
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/_index.en.md
similarity index 87%
rename from docs/document/content/concepts/distsql/syntax/_index.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/_index.en.md
index 02c9133..03b99dd 100644
--- a/docs/document/content/concepts/distsql/syntax/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/_index.en.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1. </b>"
title = "Syntax"
weight = 1
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/ral/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/_index.cn.md
similarity index 86%
rename from docs/document/content/concepts/distsql/syntax/ral/_index.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/_index.cn.md
index 66af118..8fad927 100644
--- a/docs/document/content/concepts/distsql/syntax/ral/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/_index.cn.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1.3 </b>"
title = "RAL 语法"
weight = 3
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/ral/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/_index.en.md
similarity index 88%
rename from docs/document/content/concepts/distsql/syntax/ral/_index.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/_index.en.md
index 71734ca..fc4952b 100644
--- a/docs/document/content/concepts/distsql/syntax/ral/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/_index.en.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1.3 </b>"
title = "RAL Syntax"
weight = 3
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/ral/ral.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/ral.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/ral/ral.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/ral.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/ral/ral.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/ral.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/ral/ral.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/ral/ral.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/_index.cn.md
similarity index 86%
rename from docs/document/content/concepts/distsql/syntax/rdl/_index.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/_index.cn.md
index ce5ee36..c4fc89c 100644
--- a/docs/document/content/concepts/distsql/syntax/rdl/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/_index.cn.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1.1 </b>"
title = "RDL 语法"
weight = 1
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/_index.en.md
similarity index 86%
rename from docs/document/content/concepts/distsql/syntax/rdl/_index.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/_index.en.md
index dcfed06..fc32c15 100644
--- a/docs/document/content/concepts/distsql/syntax/rdl/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/_index.en.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1.1 </b>"
title = "RDL Syntax"
weight = 1
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-db-discovery-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-db-discovery-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-db-discovery-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-db-discovery-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-db-discovery-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-db-discovery-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-db-discovery-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-db-discovery-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-encrypt-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-encrypt-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-encrypt-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-encrypt-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-encrypt-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-encrypt-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-encrypt-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-encrypt-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-readwrite-splitting-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-readwrite-splitting-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-readwrite-splitting-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-readwrite-splitting-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-readwrite-splitting-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-readwrite-splitting-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-readwrite-splitting-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-readwrite-splitting-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-resource.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-resource.cn.md
similarity index 99%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-resource.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-resource.cn.md
index 8cfcf45..4901f4f 100644
--- a/docs/document/content/concepts/distsql/syntax/rdl/rdl-resource.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-resource.cn.md
@@ -73,7 +73,7 @@ ALTER RESOURCE resource_0 (
USER=root,
PASSWORD=root,
PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
-)
+);
DROP RESOURCE resource_0, resource_1;
DROP RESOURCE resource_2, resource_3 ignore single tables;
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-resource.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-resource.en.md
similarity index 99%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-resource.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-resource.en.md
index 585f2ea..4f57036 100644
--- a/docs/document/content/concepts/distsql/syntax/rdl/rdl-resource.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-resource.en.md
@@ -73,7 +73,7 @@ ALTER RESOURCE resource_0 (
USER=root,
PASSWORD=root,
PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
-)
+);
DROP RESOURCE resource_0, resource_1;
DROP RESOURCE resource_2, resource_3 ignore single tables;
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-shadow-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-shadow-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-shadow-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-shadow-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-shadow-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-shadow-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-shadow-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-shadow-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-sharding-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-sharding-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-sharding-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-sharding-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rdl/rdl-sharding-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-sharding-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rdl/rdl-sharding-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rdl/rdl-sharding-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/_index.cn.md
similarity index 88%
rename from docs/document/content/concepts/distsql/syntax/rql/_index.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/_index.cn.md
index a6368e2..206958b 100644
--- a/docs/document/content/concepts/distsql/syntax/rql/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/_index.cn.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1.2 </b>"
title = "RQL 语法"
weight = 2
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/rql/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/_index.en.md
similarity index 89%
rename from docs/document/content/concepts/distsql/syntax/rql/_index.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/_index.en.md
index fbbb0b9..bb134e2 100644
--- a/docs/document/content/concepts/distsql/syntax/rql/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/_index.en.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.1.2 </b>"
title = "RQL Syntax"
weight = 2
chapter = true
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-db-discovery-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-db-discovery-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-db-discovery-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-db-discovery-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-db-discovery-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-db-discovery-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-db-discovery-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-db-discovery-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-encrypt-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-encrypt-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-encrypt-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-encrypt-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-encrypt-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-encrypt-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-encrypt-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-encrypt-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-readwrite-splitting-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-readwrite-splitting-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-readwrite-splitting-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-readwrite-splitting-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-readwrite-splitting-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-readwrite-splitting-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-readwrite-splitting-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-readwrite-splitting-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-resource.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-resource.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-resource.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-resource.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-resource.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-resource.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-resource.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-resource.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-shadow-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-shadow-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-shadow-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-shadow-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-shadow-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-shadow-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-shadow-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-shadow-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-sharding-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-sharding-rule.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-sharding-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-sharding-rule.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-sharding-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-sharding-rule.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-sharding-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-sharding-rule.en.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-single-table.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-single-table.cn.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-single-table.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-single-table.cn.md
diff --git a/docs/document/content/concepts/distsql/syntax/rql/rql-single-table.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-single-table.en.md
similarity index 100%
rename from docs/document/content/concepts/distsql/syntax/rql/rql-single-table.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/syntax/rql/rql-single-table.en.md
diff --git a/docs/document/content/concepts/distsql/usage/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/_index.cn.md
similarity index 90%
rename from docs/document/content/concepts/distsql/usage/_index.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/_index.cn.md
index 723a555..0a9e103 100644
--- a/docs/document/content/concepts/distsql/usage/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/_index.cn.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.2 </b>"
title = "使用"
weight = 2
chapter = true
diff --git a/docs/document/content/concepts/distsql/usage/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/_index.en.md
similarity index 88%
rename from docs/document/content/concepts/distsql/usage/_index.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/_index.en.md
index 4567f0f..66a461d 100644
--- a/docs/document/content/concepts/distsql/usage/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/_index.en.md
@@ -1,5 +1,4 @@
+++
-pre = "<b>3.3.2 </b>"
title = "Usage"
weight = 2
chapter = true
diff --git a/docs/document/content/concepts/distsql/usage/db-discovery.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/db-discovery.cn.md
similarity index 97%
rename from docs/document/content/concepts/distsql/usage/db-discovery.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/db-discovery.cn.md
index a9dcdb3..cb6d93c 100644
--- a/docs/document/content/concepts/distsql/usage/db-discovery.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/db-discovery.cn.md
@@ -22,19 +22,19 @@ weight = 5
1. 连接到 ShardingProxy
2. 创建分布式数据库
-```SQL
+```sql
CREATE DATABASE discovery_db;
```
3. 使用新创建的数据库
-```SQL
+```sql
USE discovery_db;
```
4. 配置数据源信息
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -58,7 +58,7 @@ PASSWORD=root
5. 创建数据库发现规则
-```SQL
+```sql
CREATE DB_DISCOVERY RULE group_0 (
RESOURCES(ds_0,ds_1),
TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron=''))
@@ -67,7 +67,7 @@ TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron=''))
6. 修改数据库发现规则
-```SQL
+```sql
ALTER DB_DISCOVERY RULE group_0 (
RESOURCES(ds_0,ds_1,ds_2),
TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec' ,keepAliveCron=''))
@@ -76,19 +76,19 @@ TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec' ,keepAliveCron=''))
7. 删除数据库发现规则
-```SQL
+```sql
DROP DB_DISCOVERY RULE group_0;
```
8. 删除数据源
-```SQL
+```sql
DROP RESOURCE ds_0,ds_1,ds_2;
```
9. 删除分布式数据库
-```SQL
+```sql
DROP DATABASE discovery_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/db-discovery.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/db-discovery.en.md
similarity index 97%
rename from docs/document/content/concepts/distsql/usage/db-discovery.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/db-discovery.en.md
index f2ffb8b..61d3cea 100644
--- a/docs/document/content/concepts/distsql/usage/db-discovery.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/db-discovery.en.md
@@ -22,19 +22,19 @@ weight = 5
1. Connect to ShardingProxy
2. Create a distributed database
-```SQL
+```sql
CREATE DATABASE discovery_db;
```
3. Use newly created database
-```SQL
+```sql
USE discovery_db;
```
4. Configure data source information
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -58,7 +58,7 @@ PASSWORD=root
5. Create DB discovery rule
-```SQL
+```sql
CREATE DB_DISCOVERY RULE group_0 (
RESOURCES(ds_0,ds_1),
TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron=''))
@@ -67,7 +67,7 @@ TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron=''))
6. Alter DB discovery rule
-```SQL
+```sql
ALTER DB_DISCOVERY RULE group_0 (
RESOURCES(ds_0,ds_1,ds_2),
TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec' ,keepAliveCron=''))
@@ -76,19 +76,19 @@ TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec' ,keepAliveCron=''))
7. Drop db_discovery rule
-```SQL
+```sql
DROP DB_DISCOVERY RULE group_0;
```
8. Drop resource
-```SQL
+```sql
DROP RESOURCE ds_0,ds_1,ds_2;
```
9. Drop distributed database
-```SQL
+```sql
DROP DATABASE discovery_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/encrypt-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/encrypt-rule.cn.md
similarity index 96%
rename from docs/document/content/concepts/distsql/usage/encrypt-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/encrypt-rule.cn.md
index eb15c7e..4dd76a8 100644
--- a/docs/document/content/concepts/distsql/usage/encrypt-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/encrypt-rule.cn.md
@@ -22,19 +22,19 @@ weight = 3
1. 连接到 ShardingProxy
2. 创建分布式数据库
-```SQL
+```sql
CREATE DATABASE encrypt_db;
```
3. 使用新创建的数据库
-```SQL
+```sql
USE encrypt_db;
```
4. 配置数据源信息
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -43,9 +43,10 @@ USER=root,
PASSWORD=root
);
```
+
5. 创建加密表
-```SQL
+```sql
CREATE TABLE `t_encrypt` (
`order_id` int NOT NULL,
`user_plain` varchar(45) DEFAULT NULL,
@@ -56,7 +57,7 @@ CREATE TABLE `t_encrypt` (
6. 创建加密规则
-```SQL
+```sql
CREATE ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME=AES,PROPERTIES('aes-key-value'='123456abc'))),
@@ -66,7 +67,7 @@ COLUMNS(
7. 修改加密规则
-```SQL
+```sql
CREATE ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME=AES,PROPERTIES('aes-key-value'='123456abc'))),
@@ -75,19 +76,19 @@ COLUMNS(
8. 删除加密规则
-```SQL
+```sql
DROP ENCRYPT RULE t_encrypt;
```
9. 删除数据源
-```SQL
+```sql
DROP RESOURCE ds_0;
```
10. 删除分布式数据库
-```SQL
+```sql
DROP DATABASE encrypt_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/encrypt-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/encrypt-rule.en.md
similarity index 96%
rename from docs/document/content/concepts/distsql/usage/encrypt-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/encrypt-rule.en.md
index bddcecc..e88d080 100644
--- a/docs/document/content/concepts/distsql/usage/encrypt-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/encrypt-rule.en.md
@@ -22,19 +22,19 @@ weight = 3
1. Connect to ShardingProxy
2. Create a distributed database
-```SQL
+```sql
CREATE DATABASE encrypt_db;
```
3. Use newly created database
-```SQL
+```sql
USE encrypt_db;
```
4. Configure data source information
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -45,7 +45,7 @@ PASSWORD=root
```
5. Create encrypt table
-```SQL
+```sql
CREATE TABLE `t_encrypt` (
`order_id` int NOT NULL,
`user_plain` varchar(45) DEFAULT NULL,
@@ -56,7 +56,7 @@ CREATE TABLE `t_encrypt` (
6. Create encrypt rule
-```SQL
+```sql
CREATE ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME=AES,PROPERTIES('aes-key-value'='123456abc'))),
@@ -66,7 +66,7 @@ COLUMNS(
7. Alter encrypt rule
-```SQL
+```sql
CREATE ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME=AES,PROPERTIES('aes-key-value'='123456abc'))),
@@ -75,19 +75,19 @@ COLUMNS(
8. Drop encrypt rule
-```SQL
+```sql
DROP ENCRYPT RULE t_encrypt;
```
9. Drop resource
-```SQL
+```sql
DROP RESOURCE ds_0;
```
10. Drop distributed database
-```SQL
+```sql
DROP DATABASE encrypt_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/readwirte-splitting-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/readwirte-splitting-rule.cn.md
similarity index 96%
rename from docs/document/content/concepts/distsql/usage/readwirte-splitting-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/readwirte-splitting-rule.cn.md
index 828c266..29f180a 100644
--- a/docs/document/content/concepts/distsql/usage/readwirte-splitting-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/readwirte-splitting-rule.cn.md
@@ -22,19 +22,19 @@ weight = 2
1. 连接到 ShardingProxy
2. 创建分布式数据库
-```SQL
+```sql
CREATE DATABASE readwrite_splitting_db;
```
3. 使用新创建的数据库
-```SQL
+```sql
USE readwrite_splitting_db;
```
4. 配置数据源信息
-```SQL
+```sql
ADD RESOURCE write_ds (
HOST=127.0.0.1,
PORT=3306,
@@ -52,7 +52,7 @@ PASSWORD=root
5. 创建读写分离规则
-```SQL
+```sql
CREATE READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
@@ -62,7 +62,7 @@ TYPE(NAME=random)
6. 修改读写分离规则
-```SQL
+```sql
ALTER READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
@@ -72,19 +72,19 @@ TYPE(NAME=random,PROPERTIES(read_weight='2:0'))
7. 删除读写分离规则
-```SQL
+```sql
DROP READWRITE_SPLITTING RULE group_0;
```
8. 删除数据源
-```SQL
+```sql
DROP RESOURCE write_ds,read_ds;
```
9. 删除分布式数据库
-```SQL
+```sql
DROP DATABASE readwrite_splitting_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/readwirte-splitting-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/readwirte-splitting-rule.en.md
similarity index 97%
rename from docs/document/content/concepts/distsql/usage/readwirte-splitting-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/readwirte-splitting-rule.en.md
index bae4ee1..70b94e9 100644
--- a/docs/document/content/concepts/distsql/usage/readwirte-splitting-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/readwirte-splitting-rule.en.md
@@ -22,19 +22,19 @@ weight = 2
1. Connect to ShardingProxy
2. Create a distributed database
-```SQL
+```sql
CREATE DATABASE readwrite_splitting_db;
```
3. Use newly created database
-```SQL
+```sql
USE readwrite_splitting_db;
```
4. Configure data source information
-```SQL
+```sql
ADD RESOURCE write_ds (
HOST=127.0.0.1,
PORT=3306,
@@ -52,7 +52,7 @@ PASSWORD=root
5. Create readwrite_splitting rule
-```SQL
+```sql
CREATE READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
@@ -62,7 +62,7 @@ TYPE(NAME=random)
6. Alter readwrite_splitting rule
-```SQL
+```sql
ALTER READWRITE_SPLITTING RULE group_0 (
WRITE_RESOURCE=write_ds,
READ_RESOURCES(read_ds),
@@ -72,19 +72,19 @@ TYPE(NAME=random,PROPERTIES(read_weight='2:0'))
7. Drop readwrite_splitting rule
-```SQL
+```sql
DROP READWRITE_SPLITTING RULE group_0;
```
8. Drop resource
-```SQL
+```sql
DROP RESOURCE write_ds,read_ds;
```
9. Drop distributed database
-```SQL
+```sql
DROP DATABASE readwrite_splitting_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/shadow-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/shadow-rule.cn.md
similarity index 97%
rename from docs/document/content/concepts/distsql/usage/shadow-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/shadow-rule.cn.md
index 5f74928..d7e4af7 100644
--- a/docs/document/content/concepts/distsql/usage/shadow-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/shadow-rule.cn.md
@@ -22,19 +22,19 @@ weight = 5
1. 连接到 ShardingProxy
2. 创建分布式数据库
-```SQL
+```sql
CREATE DATABASE shadow_db;
```
3. 使用新创建的数据库
-```SQL
+```sql
USE shadow_db;
```
4. 配置数据源信息
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -58,7 +58,7 @@ PASSWORD=root
5. 创建影子库压测规则
-```SQL
+```sql
CREATE SHADOW RULE group_0(
SOURCE=ds_0,
SHADOW=ds_1,
@@ -68,7 +68,7 @@ t_order_item((TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar"))))
6. 修改影子库压测规则
-```SQL
+```sql
ALTER SHADOW RULE group_0(
SOURCE=ds_0,
SHADOW=ds_2,
@@ -77,19 +77,19 @@ t_order_item((TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar"))))
7. 删除影子库压测规则
-```SQL
+```sql
DROP SHADOW RULE group_0;
```
8. 删除数据源
-```SQL
+```sql
DROP RESOURCE ds_0,ds_1,ds_2;
```
9. 删除分布式数据库
-```SQL
+```sql
DROP DATABASE shadow_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/shadow-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/shadow-rule.en.md
similarity index 97%
rename from docs/document/content/concepts/distsql/usage/shadow-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/shadow-rule.en.md
index 1ba5b42..d4d7b3d 100644
--- a/docs/document/content/concepts/distsql/usage/shadow-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/shadow-rule.en.md
@@ -22,19 +22,19 @@ weight = 5
1. Connect to ShardingProxy
2. Create a distributed database
-```SQL
+```sql
CREATE DATABASE shadow_db;
```
3. Use newly created database
-```SQL
+```sql
USE shadow_db;
```
4. Configure data source information
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -58,7 +58,7 @@ PASSWORD=root
5. Create shadow rule
-```SQL
+```sql
CREATE SHADOW RULE group_0(
SOURCE=ds_0,
SHADOW=ds_1,
@@ -68,7 +68,7 @@ t_order_item((TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar"))))
6. Alter shadow rule
-```SQL
+```sql
ALTER SHADOW RULE group_0(
SOURCE=ds_0,
SHADOW=ds_2,
@@ -77,19 +77,19 @@ t_order_item((TYPE(NAME=SIMPLE_NOTE, PROPERTIES("shadow"="true", "foo"="bar"))))
7. Drop shadow rule
-```SQL
+```sql
DROP SHADOW RULE group_0;
```
8. Drop resource
-```SQL
+```sql
DROP RESOURCE ds_0,ds_1,ds_2;
```
9. Drop distributed database
-```SQL
+```sql
DROP DATABASE shadow_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/sharding-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/sharding-rule.cn.md
similarity index 96%
rename from docs/document/content/concepts/distsql/usage/sharding-rule.cn.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/sharding-rule.cn.md
index 8dc453a..6d88dad 100644
--- a/docs/document/content/concepts/distsql/usage/sharding-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/sharding-rule.cn.md
@@ -22,19 +22,19 @@ weight = 1
1. 连接到 ShardingSphere-Proxy
2. 创建分布式数据库
-```SQL
+```sql
CREATE DATABASE sharding_db;
```
3. 使用新创建的数据库
-```SQL
+```sql
USE sharding_db;
```
4. 配置数据源信息
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -54,7 +54,7 @@ PASSWORD=root
5. 创建分片规则
-```SQL
+```sql
CREATE SHARDING TABLE RULE t_order(
RESOURCES(ds_0,ds_1),
SHARDING_COLUMN=order_id,
@@ -65,7 +65,7 @@ GENERATED_KEY(COLUMN=order_id,TYPE(NAME=snowflake,PROPERTIES("worker-id"=123)))
6. 创建切分表
-```SQL
+```sql
CREATE TABLE `t_order` (
`order_id` int NOT NULL,
`user_id` int NOT NULL,
@@ -76,25 +76,25 @@ CREATE TABLE `t_order` (
7. 删除切分表
-```SQL
+```sql
DROP TABLE t_order;
```
8. 删除分片规则
-```SQL
+```sql
DROP SHARDING TABLE RULE t_order;
```
9. 删除数据源
-```SQL
+```sql
DROP RESOURCE ds_0, ds_1;
```
10. 删除分布式数据库
-```SQL
+```sql
DROP DATABASE sharding_db;
```
diff --git a/docs/document/content/concepts/distsql/usage/sharding-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/sharding-rule.en.md
similarity index 97%
rename from docs/document/content/concepts/distsql/usage/sharding-rule.en.md
rename to docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/sharding-rule.en.md
index ffa08a4..26ed060 100644
--- a/docs/document/content/concepts/distsql/usage/sharding-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/usage/distsql/usage/sharding-rule.en.md
@@ -22,19 +22,19 @@ weight = 1
1. Connect to ShardingSphere-Proxy
2. Create a distributed database
-```SQL
+```sql
CREATE DATABASE sharding_db;
```
3. Use newly created database
-```SQL
+```sql
USE sharding_db;
```
4. Configure data source information
-```SQL
+```sql
ADD RESOURCE ds_0 (
HOST=127.0.0.1,
PORT=3306,
@@ -54,7 +54,7 @@ PASSWORD=root
5. Create sharding rule
-```SQL
+```sql
CREATE SHARDING TABLE RULE t_order(
RESOURCES(ds_0,ds_1),
SHARDING_COLUMN=order_id,
@@ -65,7 +65,7 @@ GENERATED_KEY(COLUMN=order_id,TYPE(NAME=snowflake,PROPERTIES("worker-id"=123)))
6. Create sharding table
-```SQL
+```sql
CREATE TABLE `t_order` (
`order_id` int NOT NULL,
`user_id` int NOT NULL,
@@ -76,25 +76,25 @@ CREATE TABLE `t_order` (
7. Drop sharding table
-```SQL
+```sql
DROP TABLE t_order;
```
8. Drop sharding rule
-```SQL
+```sql
DROP SHARDING TABLE RULE t_order;
```
9. Drop resource
-```SQL
+```sql
DROP RESOURCE ds_0, ds_1;
```
10. Drop distributed database
-```SQL
+```sql
DROP DATABASE sharding_db;
```