You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2021/09/20 09:42:18 UTC
[shardingsphere] branch master updated: Modify the
Readwrite-Splitting document in RQL Syntax (#12377)
This is an automated email from the ASF dual-hosted git repository.
panjuan 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 8bc1718 Modify the Readwrite-Splitting document in RQL Syntax (#12377)
8bc1718 is described below
commit 8bc17187ef553ad2aa7b3719106e34ee1e2d7141
Author: yx9o <ya...@163.com>
AuthorDate: Mon Sep 20 17:41:31 2021 +0800
Modify the Readwrite-Splitting document in RQL Syntax (#12377)
* Modify the Readwrite-Splitting document in RQL Syntax
* update
* update
---
.../syntax/rql/rql-readwrite-splitting-rule.cn.md | 22 ++++++++---------
.../syntax/rql/rql-readwrite-splitting-rule.en.md | 28 +++++++++++-----------
2 files changed, 25 insertions(+), 25 deletions(-)
diff --git a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md
index 4367eff..b2b6375 100644
--- a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md
+++ b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.cn.md
@@ -11,14 +11,14 @@ SHOW READWRITE_SPLITTING RULES [FROM schemaName]
## 说明
-| 列 | 说明 |
-| ----------------------- | ------------------------------------ |
-| name | 规则名称 |
-| autoAwareDataSourceName | 自动发现数据源名称（配置动态读写分离规则显示）|
-| writeDataSourceName | 写数据源名称 |
-| readDataSourceNames | 读数据源名称列表 |
-| loadBalancerType | 负载均衡算法类型 |
-| loadBalancerProps | 负载均衡算法参数 |
+| 列 | 说明 |
+| --------------------------- | ------------------------------------ |
+| name | 规则名称 |
+| auto_aware_data_source_name | 自动发现数据源名称（配置动态读写分离规则显示）|
+| write_data_source_name | 写数据源名称 |
+| read_data_source_names | 读数据源名称列表 |
+| load_balancer_type | 负载均衡算法类型 |
+| load_balancer_props | 负载均衡算法参数 |
## 示例
@@ -26,7 +26,7 @@ SHOW READWRITE_SPLITTING RULES [FROM schemaName]
```sql
mysql> show readwrite_splitting rules;
+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
-| name | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps |
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
| ms_group_0 | NULL | ds_primary | ds_slave_0, ds_slave_1 | random | |
+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
@@ -37,7 +37,7 @@ mysql> show readwrite_splitting rules;
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
-| name | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps |
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
| pr_ds | ms_group_0 | NULL | | random | read_weight=2:1} |
+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
@@ -48,7 +48,7 @@ mysql> show readwrite_splitting rules from readwrite_splitting_db;
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
-| name | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps |
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
| pr_ds | ms_group_0 | write_ds | read_ds_0, read_ds_1 | random | read_weight=2:1 |
+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
diff --git a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md
index 60f89f4..0c58ed4 100644
--- a/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md
+++ b/docs/document/content/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule.en.md
@@ -11,44 +11,44 @@ SHOW READWRITE_SPLITTING RULES [FROM schemaName]
## Description
-| Column | Description |
-| ----------------------- | ------------------------------------ |
-| name | Rule name |
-| autoAwareDataSourceName | Auto-Aware discovery data source name（Display configuration dynamic read-write separation rules）|
-| writeDataSourceName | Write data source name |
-| readDataSourceNames | Read data source name list |
-| loadBalancerType | Load balance algorithm type |
-| loadBalancerProps | Load balance algorithm parameter |
+| Column | Description |
+| --------------------------- | ------------------------------------ |
+| name | Rule name |
+| auto_aware_data_source_name | Auto-Aware discovery data source name（Display configuration dynamic readwrite splitting rules）|
+| write_data_source_name | Write data source name |
+| read_data_source_names | Read data source name list |
+| load_balancer_type | Load balance algorithm type |
+| load_balancer_props | Load balance algorithm parameter |
## Example
-*Static Read-write Separation Rules*
+*Static Readwrite Splitting Rules*
```sql
mysql> show readwrite_splitting rules;
+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
-| name | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps |
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
| ms_group_0 | NULL | ds_primary | ds_slave_0, ds_slave_1 | random | |
+------------+-------------------------+---------------------+--------------------------+------------------+------------------------+
1 row in set (0.00 sec)
```
-*Dynamic Read-write Separation Rules*
+*Dynamic Readwrite Splitting Rules*
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
-| name | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps |
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
| pr_ds | ms_group_0 | NULL | | random | read_weight=2:1} |
+-------+-------------------------+---------------------+---------------------+------------------+------------------------+
1 row in set (0.01 sec)
```
-*Static Read-write Separation Rules And Dynamic Read-write Separation Rules*
+*Static Readwrite Splitting Rules And Dynamic Readwrite Splitting Rules*
```sql
mysql> show readwrite_splitting rules from readwrite_splitting_db;
+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
-| name | autoAwareDataSourceName | writeDataSourceName | readDataSourceNames | loadBalancerType | loadBalancerProps |
+| name | auto_aware_data_source_name | write_data_source_name | read_data_source_names | load_balancer_type | load_balancer_props |
+-------+-------------------------+---------------------+------------------------+------------------+------------------------+
| pr_ds | ms_group_0 | write_ds | read_ds_0, read_ds_1 | random | read_weight=2:1 |
+-------+-------------------------+---------------------+------------------------+------------------+------------------------+