Using TiDB for High-Concurrency Event Management
The article details how TiDB was deployed for the high-concurrency '818 Global Car Night' event, providing robust database solutions for real-time transactions and analytics.
"818 Global Car Night" is a major automotive event hosted by the Automobile Association and Hunan Satellite TV, featuring activities like car auctions and live broadcasts. The event's high concurrency demands led to the adoption of TiDB's two-site three-center architecture for database management.
The system handles peak loads of millions of users, with concurrent transactions reaching tens of thousands. TiDB's features like real-time HTAP, seamless horizontal scaling, and MySQL compatibility were key factors in its selection.
The deployment includes TiDB, PD, TiKV, TiFlash, and TiCDC components across five data centers in two cities, ensuring high availability and disaster recovery.
Testing confirmed the cluster's resilience, with recovery times under 30 seconds during failures. Performance optimizations, such as adjusting disk mount parameters, improved throughput to 60K TPS.
Challenges included TiFlash's unstable response times and TiCDC's handling limitations for single tables, which are being addressed by the development team.
The solution successfully supported the event's requirements, demonstrating TiDB's effectiveness in managing large-scale, high-concurrency scenarios.
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.