Case Study: VIPKid achieves scalable real-time analytics and multi-dimensional query performance with PingCAP TiDB

Why We Chose a Distributed SQL Database to Complement MySQL

VIPKid, an online English education company in China, needed a database that could keep up with rapid data growth, high write volumes, and complex multi-dimensional queries across sharded core applications. Its existing MySQL setup and sharding approach created storage bottlenecks, added application complexity, and made cross-shard querying difficult.

To solve this, VIPKid adopted PingCAP’s TiDB distributed SQL database, along with TiFlash, DM, TiDB Dashboard, and BR for analytics, replication, troubleshooting, and backup. PingCAP’s solution improved real-time HTAP analytics, reduced BI cluster costs by 35%, and made large-scale queries, hotspot detection, and backups far more efficient while preserving strong consistency and high availability.

VIPKid

Chao Xu

Senior DBA Engineer