TiDB Database Deployment and Operational Practices at AutoHome

TiDB, developed by PingCAP, is an open‑source distributed relational database compatible with the MySQL protocol, offering horizontal scalability, high availability, strong consistency, and HTAP capabilities. Since its introduction in 2015, TiDB has progressed through multiple major versions, with the latest being 6.1.

The mobile internet era has created massive data storage challenges for traditional relational databases, prompting the emergence of NewSQL solutions like TiDB, which excels in handling large‑scale data, new data models, and elastic scaling requirements.

AutoHome began experimenting with TiDB in 2019 (version 2.0) and, after the release of TiDB 4.0 with TiFlash support in 2020, expanded its usage across critical services such as fan communities, dealer platforms, financial reporting, intelligent recommendation pools, and the 818 interactive event platform. In 2022, the TiDB cluster was upgraded to leverage MPP features of version 5.x.

Key applications include:

Intelligent Recommendation Resource Pool: Replaced multiple MySQL instances handling billions of rows across dozens of wide tables, solving storage limitations, schema change latency, and synchronization delays.

Financial Auditing and Reporting: Consolidated diverse data sources into TiDB to enable timely multi‑table joins and reduce reporting latency.

818 Interactive Event Platform: Adopted TiDB for its high‑availability, multi‑datacenter requirements to support large‑scale interactive features such as red‑packet giveaways and flash sales.

TiDB’s architecture comprises TiDB Server, PD (Placement Driver), and TiKV components, each communicating to form a complete distributed system.

Operationally, AutoHome built an automated TiDB management platform combining native TiDB tools with custom automation to handle monitoring, scaling, and incident resolution. The automation framework addresses tasks such as backup, restore, cluster upgrades, and performance tuning.

Challenges encountered during deployment included migration complexity, schema compatibility, and ensuring zero‑downtime during upgrades; these were mitigated through thorough testing, phased rollouts, and leveraging TiDB’s online schema change capabilities.

In conclusion, TiDB’s MySQL compatibility, scalability, high availability, strong consistency, and HTAP features have enabled AutoHome to modernize its data infrastructure across multiple critical business lines, and ongoing efforts focus on further automation, testing TiDB 6.0 features, and exploring containerized deployments.