Business Scenario

The client's IoT platform manages 50 million sensors using MySQL for metadata and ClickHouse for telemetry, but suffers from slow ETL syncs, scaling limitations, and unreliable disaster recovery. They now need an HTAP solution that combines real-time operations with analytics, delivers better performance than ClickHouse for complex queries, and ensures reliable cross-region recovery - all while handling massive sensor data volumes.

Business Challenges

Integrated Database Architecture

Enable metadata and sensor data to share a single database cluster, thereby simplifying the IT architecture and improving business efficiency.

Data Reliability

HexaDB supports remote real-time disaster recovery, completely solving the problem of remote data consistency.

HexaDB's Performance Surpasses ClickHouse

HexaDB's real-time big data analytics performance is superior to the current ClickHouse solution.
Solutions

1.HexaDB Features an HTAP Integrated Architecture

The HexaDB-H HTAP engine supports both high-concurrency online transactions and complex query analysis simultaneously.

2.HexaDB's Disaster Recovery Capability for Two Locations and Three Centers

HexaDB-H's disaster recovery ensures zero data loss (RPO=0) for planned operations and near-instant recovery (RPO<60s) for unexpected outages across multiple sites.

3.HexaDB's Hybrid Storage and Computing Engine

HexaDB's xStore engine enables columnar storage/computing, while its distributed query engine excels at multi-table joins and aggregations.

4.HexaDB's Monitoring and Operation & Maintenance Ecosystem

HexaDB is compatible with the monitoring platforms of ecosystem partners, enabling full-process operation and management of the HexaDB database.

Customer Benefits

Business Agility Boost

HexaDB cuts IoT health alerts from 60s to 5s with <2s data analysis.

Reduced Operation and Maintenance Investment

Real-time disaster recovery eliminates weekly data fixes, slashing maintenance costs.

Improved Cost-Effectiveness

With the same hardware resources, the business capacity has increased by 5 times (from 10 to 50).

Seamlessly integrates with existing O&M platforms.

The HexaDB database is adapted to the original operation and maintenance platform for smooth management integration.