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 2023/02/15 04:09:53 UTC
[shardingsphere] branch master updated: Update DistSQL `SHOW READWRITE_SPLITTING RULE` document (#24172)
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 2740705f212 Update DistSQL `SHOW READWRITE_SPLITTING RULE` document (#24172)
2740705f212 is described below
commit 2740705f2124afcabf4551af899f087d3d3382b7
Author: Zichao <57...@users.noreply.github.com>
AuthorDate: Wed Feb 15 12:09:45 2023 +0800
Update DistSQL `SHOW READWRITE_SPLITTING RULE` document (#24172)
---
.../db-discovery/show-db-discovery-rule.en.md | 2 +-
.../show-readwrite-splitting-rule.cn.md | 43 ++++++++++++++++++++--
.../show-readwrite-splitting-rule.en.md | 43 ++++++++++++++++++++--
3 files changed, 79 insertions(+), 9 deletions(-)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/db-discovery/show-db-discovery-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/db-discovery/show-db-discovery-rule.en.md
index a75fba59ba3..e791c19434f 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/db-discovery/show-db-discovery-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/db-discovery/show-db-discovery-rule.en.md
@@ -113,7 +113,7 @@ mysql> SHOW DB_DISCOVERY RULE group_0;
### Reserved word
-`SHOW`, `DB_DISCOVERY`, `RULES`, `FROM`
+`SHOW`, `DB_DISCOVERY`, `RULE`, `RULES`, `FROM`
### Related links
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.cn.md
index 90df2346858..ad526855c27 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.cn.md
@@ -1,11 +1,11 @@
+++
-title = "SHOW READWRITE_SPLITTING RULES"
+title = "SHOW READWRITE_SPLITTING RULE"
weight = 2
+++
### 描述
-`SHOW READWRITE_SPLITTING RULES` 语法用于查询指定逻辑库中的读写分离规则。
+`SHOW READWRITE_SPLITTING RULE` 语法用于查询指定逻辑库中的指定读写分离规则。
### 语法
@@ -13,7 +13,10 @@ weight = 2
{{% tab name="语法" %}}
```sql
ShowReadWriteSplittingRule::=
- 'SHOW' 'READWRITE_SPLITTING' 'RULES' ('FROM' databaseName)?
+ 'SHOW' 'READWRITE_SPLITTING' ('RULE' ruleName | 'RULES') ('FROM' databaseName)?
+
+ruleName ::=
+ identifier
databaseName ::=
identifier
@@ -75,9 +78,41 @@ mysql> SHOW READWRITE_SPLITTING RULES;
1 row in set (0.01 sec)
```
+- 查询指定逻辑库中的指定读写分离规则
+
+```sql
+SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
+```
+
+```sql
+mysql> SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_query_enabled | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| ms_group_0 | | | resource_1 | ds_0,ds_1 | random | |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+1 row in set (0.01 sec)
+```
+
+- 查询当前逻辑库中的指定读写分离规则
+
+```sql
+SHOW READWRITE_SPLITTING RULE ms_group_0;
+```
+
+```sql
+mysql> SHOW READWRITE_SPLITTING RULE ms_group_0;
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_query_enabled | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| ms_group_0 | | | resource_1 | ds_0,ds_1 | random | |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+1 row in set (0.01 sec)
+```
+
### 保留字
-`SHOW`、`READWRITE_SPLITTING`、`RULES`、`FROM`
+`SHOW`、`READWRITE_SPLITTING`、`RULE`、`RULES`、`FROM`
### 相关链接
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.en.md
index 647a4964334..cb8a058c8e5 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule.en.md
@@ -1,11 +1,11 @@
+++
-title = "SHOW READWRITE_SPLITTING RULES"
+title = "SHOW READWRITE_SPLITTING RULE"
weight = 2
+++
### Description
-The `SHOW READWRITE_SPLITTING RULES` syntax is used to query readwrite splitting rules for specified database.
+The `SHOW READWRITE_SPLITTING RULE` syntax is used to query specified readwrite splitting rules for specified database.
### Syntax
@@ -13,7 +13,10 @@ The `SHOW READWRITE_SPLITTING RULES` syntax is used to query readwrite splitting
{{% tab name="Grammar" %}}
```sql
ShowReadWriteSplittingRule::=
- 'SHOW' 'READWRITE_SPLITTING' 'RULES' ('FROM' databaseName)?
+ 'SHOW' 'READWRITE_SPLITTING' ('RULE' ruleName | 'RULES') ('FROM' databaseName)?
+
+ruleName ::=
+ identifier
databaseName ::=
identifier
@@ -75,9 +78,41 @@ mysql> SHOW READWRITE_SPLITTING RULES;
1 row in set (0.01 sec)
```
+- Query specified readwrite splitting rules for specified database.
+
+```sql
+SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
+```
+
+```sql
+mysql> SHOW READWRITE_SPLITTING RULE ms_group_0 FROM readwrite_splitting_db;
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_query_enabled | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| ms_group_0 | | | resource_1 | ds_0,ds_1 | random | |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+1 row in set (0.01 sec)
+```
+
+- Query specified readwrite splitting rules for current database.
+
+```sql
+SHOW READWRITE_SPLITTING RULE ms_group_0;
+```
+
+```sql
+mysql> SHOW READWRITE_SPLITTING RULE ms_group_0;
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| name | auto_aware_data_source_name | write_data_source_query_enabled | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+| ms_group_0 | | | resource_1 | ds_0,ds_1 | random | |
++------------+-----------------------------+---------------------------------+------------------------+------------------------+--------------------+---------------------+
+1 row in set (0.01 sec)
+```
+
### Reserved word
-`SHOW`, `READWRITE_SPLITTING`, `RULES`, `FROM`
+`SHOW`, `READWRITE_SPLITTING`, `RULE`, `RULES`, `FROM`
### Related links