课程名称: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
场景二:实时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?