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.
Integrated Database Architecture
Data Reliability
HexaDB's Performance Surpasses ClickHouse
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.
Business Agility Boost
Reduced Operation and Maintenance Investment
Improved Cost-Effectiveness
Seamlessly integrates with existing O&M platforms.

