This article explains TiDB's HTAP architecture, covering industry challenges, the row‑store TiKV and column‑store TiFlash design, MPP integration in TiDB 5.0, and a range of real‑time use cases such as dashboards, reporting, and data‑warehouse pipelines.
This article details how a company migrated its reporting architecture to TiDB, leveraged TiFlash for HTAP workloads, upgraded to version 4.0 with new tools like DM and TiUP, achieved up to four‑fold query speedups, and shares the pitfalls and optimization tips learned along the way.
This case study details how Car Home leveraged TiDB 5.1.1 with a three‑data‑center, five‑replica HTAP architecture to support the high‑traffic 818 Global Auto Festival, covering background, business requirements, database selection, system design, performance challenges, solutions, and post‑event insights.
This article details how Yiguo Group migrated from a single‑server SQL Server setup to a distributed TiDB + TiSpark architecture, highlighting performance gains, HTAP capabilities with TiFlash, ETL differences, and future data‑platform considerations.
This article recounts TiDB’s evolution from a transactional MySQL‑compatible database to a hybrid‑transactional/analytical platform, detailing its architecture, performance challenges, integration with TiSpark and TiFlash, and future plans to balance TP and AP workloads.
