课程名称: 课程版本(101)+ 1.5 Important features of TiDB database platform(TiDB 技术特性)
学习时长:
40分钟
课程收获:
学习TiDB技术架构和特性
课程内容:
Important Features of TiDB Database Platform
Before we begin
- Context: Want to know more about TiDB
- Goal: Study the architecture and features of TiDB
- Outline:
- The architecture of TiDB
- Important features
- What’s more in TiDB 4.0?
Part I: The architecture of TiDB
- An overview of TiDB’s Architecture
- Goal
- Subtopics
- Basic Architecture
- Extended Architecture with TiSpark
- Extended Architecture with TiFlash
- Key points
- Review of goal
Subtopics: Basic Architecture
Subtopics: Extended Architecture with TiSpark
Subtopics: Extended Architecture with TiFlash
Part II: Important features
- An overview of TiDB’s feature
- Goal:
- Subtopics
- Scalability
- High Availability
- Distribute Transaction
- Real-time HTAP
- Key points
- Review of goal
Subtopics: Scalability
- Scalability
- Scale out Online
- Scale in Online
- Data rebalance automatically
Subtopics: HA
- High Availablity
- Shared nothing
- Raft based
- self-recovery in fault
- Multi-active architecture with three data centers in two cities
Subtopics: Distributed transaction
- Distributed transaction
- ACID controlled by TiDB database
- Needn’t to specify sharding key in application
- Support one request based on several data nodes
Subtopics: Real-time HTAP
- Online Transaction / Real-time Online Analysis mixed load integrated Architecture
- Raft based data replica
- Row storage for TP and column storage for AP in one database
- Standard for TP & AP
- Consistent result by follower read
- No ETL,NO T+1
Part III: More in TiDB 4.0
- An overview of TiDB 4.0
- Goal:
- Subtopics
- TiUP
- Large transaction
- Tmp storage
- Dashboard
- Elastic Scheduling
- Key points
- Review of goal
Subtopics: TiUP
- Quickly to start with tidb
- Two steps to build a tidb environment online
- Support offline setup mode
- Remove disk IO detection
Subtopic: Big transacton
-
Transaction in TiDB 3.0
- 100 MB limit
- 6 MB per kv pair
- 300,000 keys transaction
-
Transaction in TiDB 4.0
- 10 GB limit (more memory needed)
- 6 MB per kv pair
Subtopic: Tmp storage
Subtopic: Dashboard
- Cluster Status
- Hot key Visualization
- Query SQL Analysis
- Performance Diagnosis
Subtopic: Elastic Scheduling
Quiz
-
Do we need to specify the sharding key in TiDB?
不需要 -
What’s the limit for transaction sizes in TiDB 4.0?
大事务限制: 100MB → 10GB (但需要更多内存)