tencent cloud

TDSQL-C for MySQL

Creating an Analysis Cluster

PDF
Focus Mode
Font Size
Last updated: 2025-10-17 12:04:14
TDSQL-C for MySQL supports two cluster types: transactional cluster and analytic cluster. The transactional cluster is primarily composed of the row-based storage engine TXSQL and columnar storage engine LibraDB, providing users with high-concurrency transaction processing and HTAP capabilities. The analysis cluster is composed of independent columnar storage engines (LibraDB), providing users with real-time data analysis and multi-source data synchronization and aggregation capabilities.

Use Cases

The analysis cluster supports columnar data storage and provides capabilities such as large-scale concurrency execution and multi-source data aggregation. It can support large-scale data analysis and data warehouse services. Note that the analysis cluster only contains read-only analysis engine instances and synchronizes the configured data source data to the analysis engine via Zero-ETL capabilities.

Billing Overview

Operation Steps

1. Log in to the purchase page, complete the Database Configuration and Instance Selection settings, and click Next.
Parameter
Description
Instance Mode
By default, only the provisioned resource mode is supported.
Instance Engine
Select Analytic Engine.
Region
Select the deployment region for your database.
AZ
Select the AZ for deployment. The AZ distribution in the corresponding region is subject to the actual purchase page.
Network
Select the network for the database instance. Currently, only Virtual Private Cloud (VPC) is supported.
For security and performance considerations, only devices within the selected VPC can access this database instance through the private network. For business access, use the private network.
Billing Mode
The yearly/monthly subscription and pay-as-you-go modes are supported.
Note:
When the billing mode is set to yearly/monthly subscription, the disk billing mode is automatically set to yearly/monthly subscription. When the billing mode is set to pay-as-you-go, the disk billing mode is automatically set to pay-as-you-go.
Node Count
Select the number of nodes for the analysis cluster, supporting 1 to 3 nodes. A single node has no high availability capability. For official environments, it is recommended to select 2 or more nodes.
Instance Specification
Select the computing specification of the instance.
Disk Type
By default, only high I/O SSD disks are supported.
Hard Disk
Select the disk size with a step length of 10 GB.
Auto-Renewal
The device will be automatically renewed monthly upon expiration when the account balance is sufficient.
2. Complete the Basic Info and Advanced Configuration settings, select the purchase Period and Quantity, and click Buy Now after confirming the fees.
Basic information settings
Parameter
Description
Cluster Name
You can choose to name the instance after creation or immediately. Only Chinese characters, letters, digits, underscores (_), hyphens (-), and periods (.) are supported. The length should be less than 60 characters.
Admin Account Name
The default name is root.
Password
8–64 characters, including any three of the following types: uppercase and lowercase letters, digits, and ~!@#$%^&*_-+=|\\(){}[]:;'<>,.?/.
Default Character Set
Only UTF8MB4 is supported by default.
Default Collation Rule
Only utf8mb4_general_ci is supported by default.
Custom Port
The default port is 3306, and custom input is supported. Port value range: 1024–65534.
Advanced configuration
Parameter
Description
Security Group
Select or create a security group.
Table Name Case Sensitivity
Case insensitive by default.
Project
Specify an associated project for the cluster you want to create.
Tag
Add tags to facilitate resource classification and management.
Terms and Conditions
Read and check the agreement terms.
3. After the cluster is purchased successfully, return to the cluster list. The cluster can be used normally when the displayed status is Running.
Note:
Note that after the analysis cluster is created, you should add a data source, synchronize data to the analysis cluster, and set database/table mapping before using and accessing the analysis cluster normally.

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback