Reducing Real-Time Query Latency With a Scale-Out HTAP Database

Reducing Real-Time Query Latency With a Scale-Out HTAP Database

In this tutorial, we'll learn Reducing Real-Time Query Latency With a Scale-Out HTAP Database.

As Autohome's businesses grew, their huge data size placed great pressure on their SQL Server database. They migrated from SQL Server to TiDB for multiple important apps.

Industry: Automobile

  • *Authors:
  • Xianqi Jin (DBA at Autohome).
  • Fan Zhang (R&D at Autohome).
  • Technical Architecture Team of Autohome Technical College.

Autohome is the leading online destination for automobile consumers in China. It's one of the most visited auto websites in the world. We provide professionally produced and user-generated content, a comprehensive automobile library, and extensive automobile listing information, covering the entire car purchase and ownership cycle.

The Autohome community forum is one of our oldest applications, with 100 million+ daily visits and 1 billion+ daily interface calls. As our data size rapidly grew, SQL Server became our database bottleneck. Sharding didn't meet our app requirements, and scaling database capacity affected apps. We looked for a new database solution.

After we compared TiDB, Apache Ignite, and CockroachDB, we chose TiDB, an open-source, distributed, Hybrid Transactional/Analytical Processing (HTAP) database. Thanks to its horizontal scalability, now we can easily scale out our database, and our transactional 99th percentile latency is within 12 ms.

In 2020, TiDB also served as the underlying storage for our big sales promotion with hundreds of thousands of Queries Per Second (QPS)Our real-time query latency was reduced from 0.5 s to 0.01 s. TiDB's 99th percentile latency was within 20 ms.

This post introduces how TiDB helps us achieve database scaling and real-time analytics, and covers:

  • Our forum reply app's pain points.
  • Why we chose TiDB over Ignite and CockroachDB.
  • How we use TiDB in the forum reply app.
  • Why and how we use TiDB in our big sales promotion app.

high availability real-time analytics htap database scalability database management system

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

System Databases in SQL Server

In SSMS, we many of may noticed System Databases under the Database Folder. But how many of us knows its purpose?. In this article lets discuss about the System Databases in SQL Server.

4 Real-Time Data Analytics Predictions for 2021

Data management, analytics, data science and real-time systems will converge enabling automated and self-learning solutions for real-time business. 4 Real-Time Data Analytics Predictions for 2021. It's a pity if you miss this great article.

Real-time Analytics News Roundup for Week Ending October 3

Amazon announces general availability of its new time series database for IoT and VMware rolls out new features for its Virtual Cloud Network offering.

Real-time Analytics News Roundup for Week Ending August 8

In the news this week: Sumo Logic enhances its Observability suite, partnerships abound to bring real-time analytics and AI to more businesses, and more.

Operational Analytics: Building a Real-time Data Environment for Business

Operational Analytics: Building a Real-time Data Environment for Business. Operational analytics is being increasingly adopted by business companies to develop a data environment. Operational data analytics helps organizations to take real-time data-driven decisions.