LianjiaTech / LianjiaTech/lightning
输出的rollback文件中的SQL没有按照时间逆序输出？
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 78
- Forks
- 26
- PR merge metrics
- No merged PRs in 30d
Description
./lightning -no-defaults \
-plugin flashback \
-start-datetime "2022-06-28 16:30:00" \
-stop-datetime "2022-06-28 17:35:00" \
-event-types update \
-tables a.b \
-master-info ./master.info > flashback.sql
使用lightning生成的rollback文件，SQL好像还是按照时间顺序排列的，如果要用来进行数据恢复的话，需要将文件内容逆向输出一下：
tac flashback.sql >flashback_r.sql
请问是否可以直接输出成时间逆序的SQL文件，可以直接拿来回滚使用？
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the issue with the provided lightning command and inspect how the flashback plugin writes flashback.sql. Determine where statement ordering is produced and verify the ordering semantics against the binlog events. Done means the generated rollback file is in reverse chronological SQL order and can be used directly without running tac.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, mysql
- Domain
- cli, databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100