课程名称:课程版本(101/201/301)+ 课程名称
学习时长:10
课程收获:
课程内容:
3.6.1 Migration tools
Dumpling: export data from database to be a sql or csv file.
Dumpling written in go, github: pingcap/dumpling
Lightning: read sql dump
- Importing large amounts of new data quickly
- Restore all backup data
![TiDB Lightning architecture
rxv |829x514](file:///C:/Users/jinn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png)
DM 2.0
Table routing
Black and white table lists
Binlog
![TiDB Data Migration (DM 2.0) architecture |911x506](file:///C:/Users/jinn/AppData/Local/Temp/msohtmlclip1/01/clip_image002.png)
3.6.2 Migration from MySQL
Generate MySQL SQL file
Lightning import data into TiDB
Dumpling privilege:
- SELECT
- RELOAD
- LOCK TABLES
- REPLICATION CLIENT
学习过程中遇到的问题或延伸思考:
- 问题 1:
- 问题 2:
- 延伸思考 1:
- 延伸思考 2: