Release Notes and Announcements
- Release Notes
- Product Announcements
Beginner's Guide
Product Introduction
- Overview
- Strengths
- Use Cases
- Architecture
- Product Specifications
- Instance Types
- Product Feature List
- Database Versions
- Regions and AZs
- Common Concepts
- Use Limits
- Suggestions on Usage Specifications
Kernel Features
- Kernel Overview
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Security Features
- Stability Feature
- Analysis Engine Features
- Inspection and Repair of Kernel Issues
Purchase Guide
- Billing Overview
- Product Pricing
- Creating Cluster
- Specification Adjustment Description
- Renewal
- Payment Overdue
- Refund
- Change from Pay-as-You-Go to Yearly/Monthly Subscription
- Change from Pay-as-You-Go to Serverless Billing
- Value-Added Services Billing Overview
- Viewing Billing Statements
Getting Started
Database Audit
Serverless Service
- Serverless Introduction
- Creating and Managing a Serverless Cluster
- Elastic Scaling Management Tool
- Serverless Resource Pack
- Multi-AZ Deployment
- Configuration Change
- FAQs
- Serverless Cost Estimator
Operation Guide
- Operation Overview
- Switching Cluster Page View in Console
- Database Connection
- Instance Management
- Configuration Adjustment
- Instance Mode Management
- Cluster Management
- Scaling Instance
- Database Proxy
- Account Management
- Database Management
- Database Management Tool
- Parameter Configuration
- Multi-AZ Deployment
- GD
- Backup and Restoration
- Operation Log
- Data Migration
- Parallel Query
- Columnar Storage Index (CSI)
- Analysis Engine
- Database Security and Encryption
- Monitoring and Alarms
- Basic SQL Operations
- Connecting to TDSQL-C for MySQL Through SCF
- Tag
Practical Tutorial
White Paper
- Security White Paper
- Performance White Paper
Troubleshooting
- Connection Issues
- Performance Issues
API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Instance APIs
- Multi-Availability Zone APIs
- Other APIs
- Audit APIs
- Database Proxy APIs
- Backup and Recovery APIs
- Parameter Management APIs
- Billing APIs
- serverless APIs
- Resource Package APIs
- Account APIs
- Performance Analysis APIs
- Data Types
- Error Codes
FAQs
Service Agreement
- Service Level Agreement
- Terms of Service
TDSQL-C Policy
- Privacy Policy
- Data Privacy and Security Agreement
General References
- Standards and Certifications
Glossary
Contact Us

Adding a Data Source

Focus Mode

Font Size

Last updated: 2025-11-20 15:57:14

The analysis cluster supports the multi-source merging capability and currently supports adding data sources including TencentDB for MySQL and TDSQL-C for MySQL instances. This document introduces how to add a data source to the analysis cluster.
Prerequisites
An analysis cluster has been prepared. See Creating an Analysis Cluster.
The cluster status is Running.
Operation Steps
Note:
After an analysis cluster is created, a database account named "txsqlPlugins_analytics_repl" is created by default. This account is used by the analysis cluster to pull data from the data source. Do not delete this account.
During the initial data loading into the analysis cluster, data is pulled from the selected data source, thereby causing slow SQL. Ignore the slow SQL information generated under the "txsqlPlugins_analytics_repl" account.
1. Log in to the TDSQL-C for MySQL console and select MySQL (Analytic Cluster) at the top.
2. Click the target cluster in the cluster list on the left to enter the cluster management page.
3. Select the Data Source List page and click Add Tencent Cloud Database.
﻿
4. In the pop-up window, select the source instance and click OK. The analysis cluster supports the multi-source merging capability. For source instance selection, TencentDB for MySQL and TDSQL-C for MySQL instances are supported. The multi-source merging capability does not limit the number of added source instances. When an excessive number of source instances exist, the data synchronization loading efficiency will be affected.
Note:
Analysis clusters support the selection of cross-region source instances. However, if the physical distance between the source instance and the analysis cluster is too long, the synchronization latency will increase.
Resources need to be reserved for data synchronization. Therefore, when you need to add many source instances, it is recommended that the number of CPU cores in your analysis cluster instance specifications be greater than the number of source instances. For example, if the number of CPU cores in your analysis cluster instance specifications is 8, it is recommended to select a maximum of 7 source instances.
﻿
5. After adding a data source, you can view the source database type, source instance information, AZ, and access information in the data source list.
FAQs
How to Modify a Data Source?
The operations of modifying a data source are basically the same as adding a data source. In the Data Source Modification pop-up window, you can cancel the selected data by clicking the delete button or add a data source by selecting a source instance.
﻿