You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by yy...@apache.org on 2023/07/03 03:29:48 UTC
[shardingsphere] branch yy2so-patch-2 created (now 4634f0ee8ef)
This is an automated email from the ASF dual-hosted git repository.
yy2so pushed a change to branch yy2so-patch-2
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
at 4634f0ee8ef Update create-readwrite-splitting-rule.en.md
This branch includes the following new commits:
new 4634f0ee8ef Update create-readwrite-splitting-rule.en.md
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
[shardingsphere] 01/01: Update create-readwrite-splitting-rule.en.md
Posted by yy...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
yy2so pushed a commit to branch yy2so-patch-2
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
commit 4634f0ee8ef067a62c7cf9fa83176abe967974f1
Author: Yacine Si Tayeb <86...@users.noreply.github.com>
AuthorDate: Mon Jul 3 11:29:43 2023 +0800
Update create-readwrite-splitting-rule.en.md
---
.../create-readwrite-splitting-rule.en.md | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/create-readwrite-splitting-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/create-readwrite-splitting-rule.en.md
index 13a52b7e0d2..f6967fe2391 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/create-readwrite-splitting-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/create-readwrite-splitting-rule.en.md
@@ -1,11 +1,11 @@
+++
-title = "CREATE READWRITE_SPLITTING RULE"
+title = "Create READWRITE_SPLITTING RULE"
weight = 1
+++
## Description
-The `CREATE READWRITE_SPLITTING RULE` syntax is used to create a readwrite-splitting rule.
+The `CREATE READWRITE_SPLITTING RULE` syntax is used to create a read/write splitting rule.
### Syntax
@@ -60,16 +60,16 @@ value ::=
{{% /tab %}}
{{< /tabs >}}
-### Supplement
+### Note
-- `transactionalReadQueryStrategyType` specifies the routing strategy for read query within a transaction, please refer to [YAML configuration](/en/user-manual/shardingsphere-jdbc/yaml-config/rules/readwrite-splitting/);
+- `transactionalReadQueryStrategyType` specifies the routing strategy for the read query within a transaction, please refer to [YAML configuration](/en/user-manual/shardingsphere-jdbc/yaml-config/rules/readwrite-splitting/);
- `loadBalancerType` specifies the load balancing algorithm type, please refer to [Load Balance Algorithm](/en/user-manual/common-config/builtin-algorithm/load-balance/);
- Duplicate `ruleName` will not be created;
-- `ifNotExists` clause used for avoid `Duplicate readwrite_splitting rule` error.
+- `ifNotExists` clause used to avoid the `Duplicate readwrite_splitting rule` error.
### Example
-#### Create a readwrite-splitting rule
+#### Create a read/write splitting rule
```sql
CREATE READWRITE_SPLITTING RULE ms_group_0 (
@@ -79,9 +79,9 @@ CREATE READWRITE_SPLITTING RULE ms_group_0 (
);
```
-#### Create readwrite-splitting rule with `ifNotExists` clause
+#### Create read/write splitting rule with `ifNotExists` clause
-- readwrite-splitting rule
+- read/write splitting rule
```sql
CREATE READWRITE_SPLITTING RULE IF NOT EXISTS ms_group_0 (
@@ -91,12 +91,12 @@ CREATE READWRITE_SPLITTING RULE IF NOT EXISTS ms_group_0 (
);
```
-### Reserved word
+### Syntax
`CREATE`, `READWRITE_SPLITTING`, `RULE`, `WRITE_STORAGE_UNIT`, `READ_STORAGE_UNITS`
, `TYPE`, `NAME`, `PROPERTIES`, `TRUE`, `FALSE`
### Related links
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
+- [Syntax](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
- [Load Balance Algorithm](/en/user-manual/common-config/builtin-algorithm/load-balance/)