Tencent Cloud TCHouse-C is a managed ClickHouse service optimized for high-concurrency, sub-second, real-time analytics. It delivers an easy-to-use, flexible, and fully hosted solution, enabling you to deploy a production-ready cluster in minutes and empower massive-scale, real-time data querying and analytics, significantly accelerating the process of deriving value from your data.
Tencent Cloud TCHouse-C
A managed ClickHouse service optimized for high-concurrency, sub-second real-time analytics.
Overview
Benefits
Superior Performance
Powered by a distributed Massively Parallel Processing (MPP) architecture, Tencent Cloud TCHouse-C delivers query performance that is several times faster than traditional data warehouses, with the ability to process terabytes of data per second, per query.
Ease of Use
Deploy a ClickHouse analytics cluster in minutes via the console. Built-in operations management, monitoring, and alerting eliminate infrastructure maintenance, so you can focus on deriving insights with full SQL support.
Elastic Scalability
The Tencent Cloud TCHouse-C console enables one-click cluster scaling and node configuration adjustment. Scale resources seamlessly to accommodate rapid business growth.
High Cost-Effectiveness
Build cost-efficient managed ClickHouse clusters on cloud-native infrastructure. By leveraging ClickHouse's high-performance compression (typically achieving 10x or higher reduction), it significantly reduces storage costs and total cost of ownership (TCO) compared to traditional data warehouses.
Security and Reliability
Clusters are deployed within isolated Virtual Private Clouds (VPCs) for secure network access. With support for high-availability (HA) configurations, automatic failover ensures business continuity, transparent to your applications.
Features
Advanced OPs
Cloud Hosting
Basic OPS
Ecological Integration
Advanced OPs
- Permission management: permission management at the database table level as well as common and high-risk permission configuration policies.
- Data table management: differences between table metadata and data distribution (skew check) across nodes.
- Hot/Cold data tiering: cold data storage in COS bucket, configurable hot/cold data tiering coefficients, swap of hot/warm/cold data partitioning levels, and TTL swap.
- Backup and restore: metadata backup and cloning of non-system tables in clusters as well as data backup and restore to local tables.
- Query management: query analysis and management (running queries, historical slow queries, and query details).
- Dictionary management: association and management of dictionary tables, including those from external sources such as MySQL and ClickHouse.
- DW Studio: connection management, table/views/dictionary tables, visualized query results, smart workspace prompts, keyword highlighting, and SQL formatting.
- Metadata management: node reconstruction after scaling and regular metadata backup.
Cloud Hosting
Tencent Cloud TCHouse-C enables you to build a data warehouse at the terabyte or even petabyte scale in just a few minutes. With mature cluster management functionality, it reduces the heavy workload of cost management, cluster configuration adjustment, and parameter configuration in the console.
Basic OPS
- Lifecycle management: horizontal scaling, vertical configuration adjustment, and billing conversion on CK/ZK nodes.
- Cluster configuration management: parameter configuration and management.
- Monitoring and alarming: purchase and refund of basic (free)/advanced monitoring and alarming on CK/ZK nodes.
- Log search: log collection and exception log search on all nodes.
Ecological Integration
- Data integration: data input from multiple sources such as ClickHouse, MySQL, Oracle, DB2, PostgreSQL, CKafka, Hive, and HBase.
- Real-time writing: Oceanus real-time processing linkage for ClickHouse, with INSERT, UPDATE, and DELETE operations supported for writing to ensure data consistency.
- Cluster migration: cross-cloud data migration from self-built ClickHouse clusters to Tencent Cloud TCHouse-C.
Features
Advanced OPs
- Permission management: permission management at the database table level as well as common and high-risk permission configuration policies.
- Data table management: differences between table metadata and data distribution (skew check) across nodes.
- Hot/Cold data tiering: cold data storage in COS bucket, configurable hot/cold data tiering coefficients, swap of hot/warm/cold data partitioning levels, and TTL swap.
- Backup and restore: metadata backup and cloning of non-system tables in clusters as well as data backup and restore to local tables.
- Query management: query analysis and management (running queries, historical slow queries, and query details).
- Dictionary management: association and management of dictionary tables, including those from external sources such as MySQL and ClickHouse.
- DW Studio: connection management, table/views/dictionary tables, visualized query results, smart workspace prompts, keyword highlighting, and SQL formatting.
- Metadata management: node reconstruction after scaling and regular metadata backup.
Cloud Hosting
Tencent Cloud TCHouse-C enables you to build a data warehouse at the terabyte or even petabyte scale in just a few minutes. With mature cluster management functionality, it reduces the heavy workload of cost management, cluster configuration adjustment, and parameter configuration in the console.
Basic OPS
- Lifecycle management: horizontal scaling, vertical configuration adjustment, and billing conversion on CK/ZK nodes.
- Cluster configuration management: parameter configuration and management.
- Monitoring and alarming: purchase and refund of basic (free)/advanced monitoring and alarming on CK/ZK nodes.
- Log search: log collection and exception log search on all nodes.
Ecological Integration
- Data integration: data input from multiple sources such as ClickHouse, MySQL, Oracle, DB2, PostgreSQL, CKafka, Hive, and HBase.
- Real-time writing: Oceanus real-time processing linkage for ClickHouse, with INSERT, UPDATE, and DELETE operations supported for writing to ensure data consistency.
- Cluster migration: cross-cloud data migration from self-built ClickHouse clusters to Tencent Cloud TCHouse-C.
Scenarios
User Behavior Analysis
BI Analysis/Data Dashboard
A/B Testing Platform
Tencent Cloud TCHouse-C allows you to collect data such as clicks, operations, browsing, payments, and comments on websites, apps, and games to message channels. The data is parsed, processed, and stored by a real-time computing platform and further analyzed by Tencent Cloud TCHouse-C in multiple dimensions. Tencent Cloud TCHouse-C excels in query and responds in milliseconds in terms of real-time data extraction/analysis/drilling, retention analysis, and funnel analysis. This greatly accelerates big data analysis and processing, providing strong support for targeted marketing and membership conversion.
Scientific exploration is random and thus difficult to pre-model. Tencent Cloud TCHouse-C offers you a way to import business data at a large scale and construct a real-time data analysis platform. With faster query and flexible scaling, Tencent Cloud TCHouse-C greatly simplifies data exploration and enables real-time analysis of PV, UV, revenue, user group, and other metrics, allowing you to perform personalized analysis at any time without interruption and make informed business decisions.
A/B testing is data-driven for flexible traffic slicing. Different versions of a product can be online at the same time, and user behaviors on each version can be compared, allowing you to make better decisions using the most scientific and accurate results possible.
Tencent Cloud TCHouse-C can perform custom analysis of petabytes of log data in seconds, and features high-performance storage and data aggregation functions, making it the best choice for experiment analysis. It integrates both offline and real-time user behavior logs to compute event tracking data, makes experiment results more accurate, and speeds up your experiment cycle and model validation.
Pricing
Tencent Cloud TCHouse-C supports two billing modes: subscription and pay-as-you-go. For details, refer to Billing Overview.