You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/16 10:34:39 UTC
[GitHub] [shardingsphere] tristaZero commented on a change in pull request #11845: For #11677, update documents of RAL
tristaZero commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689420193
##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.cn.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## 定义
+
+RAL (Resource & Rule Administrate Language) 为 Apache ShardingSphere 的管理语言，负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+
+## 使用实战
+
+| 语句 | 说明 | 示例 |
+|:---------------------------------------------------|:--------------------------------------------------------------|:-----------------------------------------------|
+|set variable transaction_type = xx | 修改当前连接的事务类型, 支持LOCAL，XA，BASE | set variable transaction_type = XA |
Review comment:
Do we have the default value?
##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
- RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
- RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
Review comment:
`Administrate`? what's the exact definition of `DAL` acronym of MySQL?
##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
- RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
- RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
Review comment:
Administration? Administrator?
##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.en.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## Definition
+
+RAL (Resource & Rule Administrate Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+
+## Usage
+
+| Statement | Function | Example |
+|:---------------------------------------------------|:-----------------------------------------------------------------------------------------------------------|:----------------------------------------------|
+|set variable transaction_type = xx | Modify transaction_type of the current connection, supports LOCAL, XA, BASE | set variable transaction_type = XA |
+|show variable transaction_type | Query the transaction type of the current connection | show variable transaction_type |
+|show variable cached_connections | Query the number of cached physical database connections in the current connection | show variable cached_connections |
+|preview SQL | Preview the actual SQL | preview select * from t_order |
Review comment:
actual SQL**s**
##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.en.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## Definition
+
+RAL (Resource & Rule Administrate Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+
+## Usage
+
+| Statement | Function | Example |
+|:---------------------------------------------------|:-----------------------------------------------------------------------------------------------------------|:----------------------------------------------|
+|set variable transaction_type = xx | Modify transaction_type of the current connection, supports LOCAL, XA, BASE | set variable transaction_type = XA |
+|show variable transaction_type | Query the transaction type of the current connection | show variable transaction_type |
+|show variable cached_connections | Query the number of cached physical database connections in the current connection | show variable cached_connections |
+|preview SQL | Preview the actual SQL | preview select * from t_order |
+|set readwrite_splitting hint source = [auto / write]| For current connection, set readwrite splitting routing strategy (automatic or forced to write data source)| set readwrite_splitting hint source = write |
+|set sharding hint database_value = yy | For current connection, set sharding value for database sharding only, yy: sharding value | set sharding hint database_value = 100 |
+|add sharding hint database_value xx= yy | For current connection, add sharding value for table, xx: logic table, yy: database sharding value | add sharding hint database_value t_order= 100 |
+|add sharding hint table_value xx = yy | For current connection, add sharding value for table, xx: logic table, yy: table sharding value | add sharding hint table_value t_order = 100 |
+|clear hint | For current connection, clear all hint settings | clear hint |
+|clear [sharding hint / readwrite_splitting hint] | For current connection, clear hint settings of sharding or readwrite splitting | clear readwrite_splitting hint |
Review comment:
Are they new API and features? All these functions were developed?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org