Lindorm:Create and manage an OLAP resource group

Introduction

An OLAP resource group is a computing resource unit for complex query analysis scenarios. It provides a MySQL-compatible access interface and delivers high-concurrency, low-latency query responses. The resource group uses a storage-compute separation architecture. Data is stored in the underlying file system of the Lindorm instance. Computing resources are allocated when you create the resource group and remain active to quickly respond to query requests. You can create multiple independent resource groups as needed. All resource groups share the same underlying storage data. When you delete an idle resource group, only the computing resources are released. This does not affect the data integrity of the storage layer. This design enables elastic resource management and cost optimization.

Prerequisites

• You have activated LindormTable.

• You have activated the Lindorm compute engine.

Create an OLAP resource group

1. Log on to the Lindorm console. In the upper-left corner of the page, select the region of the instance. On the Instances page, click the ID of the target instance or click View Instance Details in the Actions column for the instance.

2. On the Instance Details page, in the Configurations section, click Resource Groups in the Actions column for Compute Engine.

3. On the Resource Group Details page, click Create Resource Group and set the following parameters:

   • For Resource Group Type, select OLAP.

   • Resource Group Name: The name of the resource group. The name can be up to 63 characters in length and can contain only lowercase letters and digits. Example: cg0.

   • Node Specifications: The available node specifications.

   • Working Nodes in Job (WORKERS): The number of worker nodes for job execution. The value must be an integer from 4 to 1024. The default value is 4. A higher number of nodes improves concurrent query performance and execution efficiency, but increases resource consumption. Configure this parameter based on your requirements.

4. Click OK to create the OLAP resource group. The process takes about 20 minutes. You can then connect to it and access data.

   Note

   • After you submit the creation request, the resource group appears on the Resource Group Details page. The status in the Status and Description column is initially Starting and changes to Running after the resource group is created. If a resource group fails to be created due to insufficient resources or IP addresses, the status in the Status and Description column changes to Failed. If the creation fails repeatedly, contact Lindorm technical support (DingTalk ID: s0s3eg3).

   • After the compute engine is activated, an extract, transform, and load (ETL) resource group named default is automatically created.

   • The default resource group supports only property configuration modifications. You cannot delete or restart this resource group.

Obtain the web UI of the resource group

The web UI provides system information about the resource group on a webpage, which lets you monitor its status.

1. On the Resource Group Details page, hover over WebUI in the Actions column.

2. Obtain the web UI address of the resource group. For example, http://alb-57k7r581oht8rd****.cn-hangzhou.alb.aliyuncsslb.com/computegroup/cg0.

Edit the resource group configuration

You can modify the node specifications and the number of worker nodes after you create an OLAP resource group.

1. On the Resource Group Details page, click Edit in the Actions column.

2. On the Update Resource Group page, you can modify the Node Specifications and Working Nodes in Job.

3. After making your changes, click OK to update the resource group configuration.

Restart the resource group

Restarting an OLAP resource group releases the existing computing resources and recreates the resource group. This action applies the modified configuration.

1. On the Resource Group Details page, in the Actions column, click Restart.

2. Click OK to restart the OLAP resource group.

Delete a resource group

You can delete a resource group when it is no longer needed.

1. On the Resource Group Details page, in the Actions column, click .

2. In the message, click Delete.

3. Click OK to delete the OLAP resource group.

Modify the default resource group

If multiple OLAP resource groups exist in a Lindorm instance, you can specify one as the default resource group for running query tasks. When you use the SQL endpoint of the compute engine to access an OLAP resource group, the system automatically connects to the default resource group. Setting a default resource group helps prevent query failures that are caused by an unspecified resource group. It also simplifies query management in an environment with multiple resource groups.

• The system applies the following rules to the default resource group:

  • When you create your first OLAP resource group, it automatically becomes the default resource group.

  • If you delete the current default resource group, the system randomly selects another OLAP resource group in the instance as the new default resource group.

• You can also manually set the default resource group on the Resource Group Details page using the switch in the Default Resource Group column.

  Note

  You can have only one default resource group. When you set a new default resource group, the previous one is automatically unset.