Product Introduction

Overview

Concepts

Cluster Architecture

Strengths

Scenarios

Purchase Guide

Billing Overview

Renewal Instructions

Overdue Policy

Refund Instructions

Configuration Adjustment Billing Instructions

Getting Started

Using Tencent Cloud TCHouse-D Through the Console

Using Tencent Cloud TCHouse-D Through a Client

Operation Guide

Cluster Operation

Monitoring and Alarm Configuration

Account Privilege Management

Data Management

Query Management

Modify Configurations

Node Management

Log Analysis

SQL Studio

Enabling Resource Isolation

Development Guide

Design of Data Table

Importing Data

Exporting Data

Basic Feature

Query Optimization

Ecological Expansion Feature

API Documentation

History

Introduction

API Category

Making API Requests

Cluster Operation APIs

Database and Table APIs

Cluster Information Viewing APIs

Hot-Cold Data Layering APIs

Database and Operation Audit APIs

User and Permission APIs

Resource Group Management APIs

Data Types

Error Codes

Cloud Ecosystem

Granting CAM Policies to Sub-accounts

Query Acceleration for Tencent Cloud DLC

Practical Tutorial

Basic Feature Usage

Advanced Features Usage

Resource Specification Selection and Optimization Suggestions

Naming Specifications and Limits to the Database and Data Table

Table Design and Data Import

Query Optimization

Suggested Usage to Avoid

Accessing TCHouse-D via JDBC over the Public Network

Performance Testing

TPC-H Performance Testing

SSB Performance Testing

TPC-DS Performance Testing

FAQs

Common Operational Issues

Common Errors

Glossary

Product Policy

Service Level Agreement

Data Processing And Security Agreement

Using Tencent Cloud TCHouse-D Through the Console

PDF

Mode fokus

Ukuran font

Terakhir diperbarui: 2024-06-27 10:39:42

This document describes how to use Tencent Cloud TCHouse-D through the console to create, manage, and execute SQL commands in the SQL workspace.
Creating Cluster
1. On the Tencent Cloud TCHouse-D introduction page, click Buy Now. Alternatively, log in to the Tencent Cloud TCHouse-D console and click Create Cluster to go to the purchase page for configuration and purchase.
2. After completing the basic configuration, cluster configuration, and log configuration, the system will display the corresponding configuration costs. Click Activate to create a cluster.
﻿
View Cluster Information
1. After the cluster is created, you can access the Tencent Cloud TCHouse-D console and select the region where the cluster is located to view the status information of all clusters in that region from the cluster list.
﻿
2. In the cluster list, click Resource ID/Name to view the basic cluster information, cluster status, configuration information, and network information.
﻿
Cluster Operation
In the console, you can conveniently manage account permissions, configure monitoring and alarms, modify configurations, and manage nodes. For details, see the Operation Guide section.
Managing Account Permissions
1. Tencent Cloud TCHouse-D offers a visual interface in the console, allowing for convenient and efficient account and permission management of clusters.
﻿
2. Click Add Account, fill in the database account, password, confirm password, and description (optional), and click Confirm to add an account. Click Modify Permissions to go to the permission modification window, where you can also view permissions.
﻿
Monitoring and Alarm Configuration
1. Tencent Cloud TCHouse-D provides a wealth of monitoring indicators to help you understand the operation status of the cluster. You can configure alarms for indicators to check operation information in real time, achieving rapid response. Click Resource ID/Name of the cluster to view cluster details, and click Cluster Monitoring to view the performance indicators of the cluster.
﻿
2. Flexible and comprehensive alarm policies can be created, so that exception alarms can be reported for all monitoring indicators. In the cluster monitoring page, click Set Alarm to create a new alarm policy.
﻿
Modifying Configuration
1. Tencent Cloud TCHouse-D supports flexible parameter configuration methods. You can comprehensively and intuitively set the parameters of BE/FE/Broker in the console, and view historical modification records. In the cluster list, click Resource ID/Name to view cluster details, and select Configurations > Modify Configurations from the left list to go to the parameter configuration page.
﻿
2. For the configuration parameters corresponding to Broker, BE, and FE, modifications to the configuration file and hot updates to the parameters are supported. An entire XML configuration file can be modified.
Node Operations
1. The node management page displays the status list of each role in the cluster. The roles include FE, BE, and BROKER. The health status, process status, node IP address, and the most recent restart time (the last time the service was manually restarted on the role management page) are displayed for each role.
﻿
2. You can restart each node. The restart methods include immediate restart, graceful restart, and rolling restart, and batch execution for the same type of nodes is supported.
Executing SQL Commands
1. In the SQL workspace, you can quickly connect to the cluster and use SQL commands to perform a series of operations. For details, see SQL Studio. Click on the console left list to access SQL Studio. In the cluster list, select the target Resource ID/Name. You can also find the entry under Query Management.
﻿
2. In the SQL studio, you can execute SQL statements, view execution records, and perform other operations.
﻿