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.
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:
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.
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.
Amazon announces general availability of its new time series database for IoT and VMware rolls out new features for its Virtual Cloud Network offering.
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 is being increasingly adopted by business companies to develop a data environment. Operational data analytics helps organizations to take real-time data-driven decisions.