This is an automated email from the ASF dual-hosted git repository.
gavinchou pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 43ff07dc9b [docs](cloud) add an example for adding compute groups
(#1223)
43ff07dc9b is described below
commit 43ff07dc9befbf9270573ad8273bc110d40aaac3
Author: yagagagaga <[email protected]>
AuthorDate: Mon Oct 28 16:50:06 2024 +0800
[docs](cloud) add an example for adding compute groups (#1223)
# Versions
- [x] dev
- [x] 3.0
- [ ] 2.1
- [ ] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../managing-compute-cluster.md | 30 ++++++++++++++--------
.../managing-compute-cluster.md | 30 ++++++++++++++--------
.../managing-compute-cluster.md | 30 ++++++++++++++--------
.../managing-compute-cluster.md | 30 ++++++++++++++--------
4 files changed, 80 insertions(+), 40 deletions(-)
diff --git a/docs/compute-storage-decoupled/managing-compute-cluster.md
b/docs/compute-storage-decoupled/managing-compute-cluster.md
index a625e88cee..85ed98d61f 100644
--- a/docs/compute-storage-decoupled/managing-compute-cluster.md
+++ b/docs/compute-storage-decoupled/managing-compute-cluster.md
@@ -37,23 +37,33 @@ In versions prior to 3.0.2, this was referred to as a
Compute Cluster.
You can view all compute groups owned by the current repository using `SHOW
COMPUTE GROUPS`.
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
## Adding Compute Groups
-When adding a BE, a compute group will be automatically added.
+Using [Add BE
](../sql-manual/sql-statements/Cluster-Management-Statements/ALTER-SYSTEM-ADD-BACKEND.md)
to add a BE into a compute group, for example:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050' PROPERTIES ("tag.compute_group_name" =
"new_group");
+```
+
+The above sql will add `host:9050` to compute group `new_group`. The BE will
be added to compute group `default_compute_group` if you omit PROPERTIES
statement, for example:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050';
+```
## Granting Compute Group Access
-```SQL
+```sql
GRANT USAGE_PRIV ON COMPUTE GROUP {compute_group_name} TO {user}
```
## Revoking Compute Group Access
-```SQL
+```sql
REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name} FROM {user}
```
@@ -61,31 +71,31 @@ REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name}
FROM {user}
To set the default compute group for the current user:
-```SQL
+```sql
SET PROPERTY 'default_compute_group' = '{clusterName}';
```
To set the default compute group for other users (this operation requires
Admin privileges):
-```SQL
+```sql
SET PROPERTY FOR {user} 'default_compute_group' = '{clusterName}';
```
To view the current user's default compute group, the value of
`default_compute_group` in the returned result is the default compute group:
-```SQL
+```sql
SHOW PROPERTY;
```
To view the default compute group of other users, this operation requires the
current user to have relevant permissions, and the value of
`default_compute_group` in the returned result is the default compute group:
-```SQL
+```sql
SHOW PROPERTY FOR {user};
```
To view all available compute groups in the current repository:
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
@@ -129,4 +139,4 @@ If the database or compute group name contains reserved
keywords, the correspond
## Scaling Compute Groups
-You can scale compute groups by adding or removing BE using `ALTER SYSTEM ADD
BACKEND` and `ALTER SYSTEM DECOMMISION BACKEND`.
\ No newline at end of file
+You can scale compute groups by adding or removing BE using `ALTER SYSTEM ADD
BACKEND` and `ALTER SYSTEM DECOMMISION BACKEND`.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/compute-storage-decoupled/managing-compute-cluster.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/compute-storage-decoupled/managing-compute-cluster.md
index d08ccfc8f6..1361a80b43 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/compute-storage-decoupled/managing-compute-cluster.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/compute-storage-decoupled/managing-compute-cluster.md
@@ -37,23 +37,33 @@ under the License.
可通过 `SHOW COMPUTE GROUPS` 查看当前仓库拥有的所有计算组。
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
## 添加计算组
-在添加 BE 时,会自动添加计算组。
+使用[Add BE
](../sql-manual/sql-statements/Cluster-Management-Statements/ALTER-SYSTEM-ADD-BACKEND.md)命令添加
BE 并为 BE 指定计算组,示例:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050' PROPERTIES ("tag.compute_group_name" =
"new_group");
+```
+
+上面命令会将`host:9050`这台节点添加到`new_group`这个计算组中,您也可以不指定计算组,默认会添加到`default_compute_group`组里,示例:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050';
+```
## 授予计算组访问权限
-```SQL
+```sql
GRANT USAGE_PRIV ON COMPUTE GROUP {compute_group_name} TO {user}
```
## 撤销计算组访问权限
-```SQL
+```sql
REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name} FROM {user}
```
@@ -61,31 +71,31 @@ REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name}
FROM {user}
为当前用户设置默认计算组:
-```SQL
+```sql
SET PROPERTY 'default_compute_group' = '{clusterName}';
```
为其他用户设置默认计算组(此操作需要 Admin 权限):
-```SQL
+```sql
SET PROPERTY FOR {user} 'default_compute_group' = '{clusterName}';
```
查看当前用户默认计算组,返回结果中`default_compute_group` 的值即为默认计算组:
-```SQL
+```sql
SHOW PROPERTY;
```
查看其他用户默认计算组,此操作需要当前用户具备相关权限,返回结果中`default_compute_group` 的值即为默认计算组:
-```SQL
+```sql
SHOW PROPERTY FOR {user};
```
查看当前仓库下所有可用的计算组:
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
@@ -121,7 +131,7 @@ SHOW COMPUTE GROUPS;
**语法**
-```SQL
+```sql
USE { [catalog_name.]database_name[@compute_group_name] | @compute_group_name }
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
index d08ccfc8f6..1361a80b43 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
@@ -37,23 +37,33 @@ under the License.
可通过 `SHOW COMPUTE GROUPS` 查看当前仓库拥有的所有计算组。
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
## 添加计算组
-在添加 BE 时,会自动添加计算组。
+使用[Add BE
](../sql-manual/sql-statements/Cluster-Management-Statements/ALTER-SYSTEM-ADD-BACKEND.md)命令添加
BE 并为 BE 指定计算组,示例:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050' PROPERTIES ("tag.compute_group_name" =
"new_group");
+```
+
+上面命令会将`host:9050`这台节点添加到`new_group`这个计算组中,您也可以不指定计算组,默认会添加到`default_compute_group`组里,示例:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050';
+```
## 授予计算组访问权限
-```SQL
+```sql
GRANT USAGE_PRIV ON COMPUTE GROUP {compute_group_name} TO {user}
```
## 撤销计算组访问权限
-```SQL
+```sql
REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name} FROM {user}
```
@@ -61,31 +71,31 @@ REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name}
FROM {user}
为当前用户设置默认计算组:
-```SQL
+```sql
SET PROPERTY 'default_compute_group' = '{clusterName}';
```
为其他用户设置默认计算组(此操作需要 Admin 权限):
-```SQL
+```sql
SET PROPERTY FOR {user} 'default_compute_group' = '{clusterName}';
```
查看当前用户默认计算组,返回结果中`default_compute_group` 的值即为默认计算组:
-```SQL
+```sql
SHOW PROPERTY;
```
查看其他用户默认计算组,此操作需要当前用户具备相关权限,返回结果中`default_compute_group` 的值即为默认计算组:
-```SQL
+```sql
SHOW PROPERTY FOR {user};
```
查看当前仓库下所有可用的计算组:
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
@@ -121,7 +131,7 @@ SHOW COMPUTE GROUPS;
**语法**
-```SQL
+```sql
USE { [catalog_name.]database_name[@compute_group_name] | @compute_group_name }
```
diff --git
a/versioned_docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
b/versioned_docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
index a625e88cee..85ed98d61f 100644
---
a/versioned_docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
+++
b/versioned_docs/version-3.0/compute-storage-decoupled/managing-compute-cluster.md
@@ -37,23 +37,33 @@ In versions prior to 3.0.2, this was referred to as a
Compute Cluster.
You can view all compute groups owned by the current repository using `SHOW
COMPUTE GROUPS`.
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
## Adding Compute Groups
-When adding a BE, a compute group will be automatically added.
+Using [Add BE
](../sql-manual/sql-statements/Cluster-Management-Statements/ALTER-SYSTEM-ADD-BACKEND.md)
to add a BE into a compute group, for example:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050' PROPERTIES ("tag.compute_group_name" =
"new_group");
+```
+
+The above sql will add `host:9050` to compute group `new_group`. The BE will
be added to compute group `default_compute_group` if you omit PROPERTIES
statement, for example:
+
+```sql
+ALTER SYSTEM ADD BACKEND 'host:9050';
+```
## Granting Compute Group Access
-```SQL
+```sql
GRANT USAGE_PRIV ON COMPUTE GROUP {compute_group_name} TO {user}
```
## Revoking Compute Group Access
-```SQL
+```sql
REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name} FROM {user}
```
@@ -61,31 +71,31 @@ REVOKE USAGE_PRIV ON COMPUTE GROUP {compute_group_name}
FROM {user}
To set the default compute group for the current user:
-```SQL
+```sql
SET PROPERTY 'default_compute_group' = '{clusterName}';
```
To set the default compute group for other users (this operation requires
Admin privileges):
-```SQL
+```sql
SET PROPERTY FOR {user} 'default_compute_group' = '{clusterName}';
```
To view the current user's default compute group, the value of
`default_compute_group` in the returned result is the default compute group:
-```SQL
+```sql
SHOW PROPERTY;
```
To view the default compute group of other users, this operation requires the
current user to have relevant permissions, and the value of
`default_compute_group` in the returned result is the default compute group:
-```SQL
+```sql
SHOW PROPERTY FOR {user};
```
To view all available compute groups in the current repository:
-```SQL
+```sql
SHOW COMPUTE GROUPS;
```
@@ -129,4 +139,4 @@ If the database or compute group name contains reserved
keywords, the correspond
## Scaling Compute Groups
-You can scale compute groups by adding or removing BE using `ALTER SYSTEM ADD
BACKEND` and `ALTER SYSTEM DECOMMISION BACKEND`.
\ No newline at end of file
+You can scale compute groups by adding or removing BE using `ALTER SYSTEM ADD
BACKEND` and `ALTER SYSTEM DECOMMISION BACKEND`.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]