【TiDB 4.0 PCTA 学习笔记】- 2.1 When to use TiDB platform(TiDB 的适用场景)@3班+漆锐

课程名称:2.1 When to use TiDB platform(TiDB 的适用场景)

学习时长:

30min

课程收获:

了解TiDB的典型适用场景

课程内容:

场景一:OLTP场景

when you need Random,Real-time Read/Write access to your big data (billions of rows),with

  • 遵循ACID
  • 支持二级索引
  • 兼容MySQL
    image

场景二:实时HTAP

  • Real-Time HTAP(hybrid transactional/analytical processing)
  • 数据汇总平台
  • 当你在OLTP场景中使用TiDB,并且你希望借助于TiFlash实现OLAP查询
    • with fresh data
    • with zero interference on OLTP performance
  • 作为数据汇总的平台

场景三:Connect with Spark Eco-system via TiSpark

  • Iterative processing
    • like traditional ETL job
  • joining datasets
    • joining large datasets from multiple data sources
    • a lot of shuffling and sorting is needed

不适合的场景

  • your data can fit on a single server
  • you need to perform heavy analytics tasks
    • scanning and aggregation on large data sets, that intermediate results can not fit in single server’s memory
  • you need sub-millisecond latency
    • take a look at Redis?