TiDB System Properties

TiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional and Analytical Processing (HTAP) workloads and is suitable for various use cases that require high availability and strong consistency with large-scale data.

TiDB Specific Characteristics:

1. Horizontal scalability
2. High Availability
   
3. Real-time HTAP
   
4. MySQL Compatible Syntax
5. Distributed Transactions with Strong Consistency
   
6. Cloud native
7. Minimize ETL

In the current database landscape, infrastructure engineers often have to use one database for online transactional processing (OLTP) and another for online analytical processing (OLAP). Seeing no good solution that can do both in real-time, PingCAP cofounders decided to build a globally scalable Hybrid Transactional/Analytical Processing (HTAP) database the open-source way.

Now, a new storage component that’s columnar-based, called TiFlash (currently in beta) is being introduced, that sits alongside TiKV.

TiDB aims to break down this separation by building an HTAP database that enables real-time business analysis based on live transactional data. With TiDB, engineers can now spend less time managing multiple database solutions, and more time delivering business value for their companies and customers.

TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB, the stateless SQL layer compatible with MySQL, for OLTP and ad-hoc OLAP workload, and TiSpark, the TiDB connector for Spark, to process complex OLAP queries.

Use Case Scenarios:

1. Amount of data is too large for a standalone database
2. Don't want to use manual sharding solutions
3. Access mode has no obvious hotspot
4. Must have transactions, strong consistency, and disaster recovery

For more information, see best scenarios for TiDB.

• Shopee (E-commerce)
  
• BookMyShow.com (E-commerce)
  
• Yiguo.com (E-commerce)
  
• JD Cloud & AI (Cloud Computing)
  
• Zhihu (Knowledge sharing)
  
• VNG (Mobile payment)
  
• Xiaomi (Consumer Electronics)
  
• Bank of Beijing (Banking)
  
• Mobike (Ridesharing)
• Jinri Toutiao (Mobile news platform)
  
• Dailymotion (Media and Entertainment)
  
• iQiyi (Media and Entertainment)
• Qunar.com (Travel)
• GAEA (Gaming)
• YOOZOO GAMES (Gaming) 
• FUNYOURS JAPAN (Gaming) 
• 360 Financial (FinTech)

See more TiDB case studies.

• 25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV
• 1.6K+ members in TiDB Community Slack, and 700+ members in TiKV Community Slack
• 1K+ community contributors 
  
• 1K+ production adopters

Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service subscription model.

Linux Kernel vs. Memory Fragmentation (Part II)
3 May 2021

Getting Started with Rails & TiDB
28 April 2021

TiKV + SPDK: Pushing the Limits of Storage Performance
26 April 2021

Announcing Establishment of Japan Office
22 April 2021

Using a GPU Boosts TiDB Analytics Performance by 10 to 150 Times
19 April 2021