Is there an SQL review platform tool that supports TiDB? (Needs to support SQL backup/rollback)

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 想知道有没有支持tidb的sql审核平台工具？（需支持sql备份/回滚）

| username: 托马斯滑板鞋

RT, I want to know if there are any SQL auditing tools/platforms that support TiDB on the market? Similar to Archery, but need to support SQL backup/rollback.

2
| username: 啦啦啦啦啦 | Original post link

SQLE supports auditing TiDB, but backup and rollback are not very clear and need to be researched. MySQL relies on binlog, and the principles are different.

3
| username: 我是人间不清醒 | Original post link

I am using the open-source Yearning to perform full snapshot backups and incremental log backups for the cluster.

4
| username: cassblanca | Original post link

Archery can also support TiDB. TiDB is 100% compatible with the MySQL 5.7 protocol. Rollback is not possible in the current version. The TiDB Binlog format is different from MySQL.

5
| username: 托马斯滑板鞋 | Original post link

SQLE does not support TiDB SQL rollback.

6
| username: 托马斯滑板鞋 | Original post link

Does Yearning support SQL rollback for TiDB?

7
| username: 啦啦啦啦啦 | Original post link

Then it is estimated that there is no support for it. At least the principle of MySQL rollback cannot be applied. TiDB’s own GC can actually roll back, but it must be within the GC time range.

8
| username: 托马斯滑板鞋 | Original post link

Due to user environment limitations and insufficient memory, they want to save a copy of the rollback SQL through the audit platform. :upside_down_face:

9
| username: 我是人间不清醒 | Original post link

Supports MySQL rollback. I haven’t encountered a rollback scenario in my SQL audit approval process. I just verified it as shown in the picture below:

image
image1380×658 82.8 KB

It will provide a rollback statement.

10
| username: 我是人间不清醒 | Original post link

You can also roll back according to the approval process.

11
| username: 昵称想不起来了 | Original post link

Following the same platform
Currently, Yearning supports TiDB SQL auditing, but it does not support TiDB rollback QAQ

12
| username: Fly-bird | Original post link

Rollback is not supported. The original poster might consider developing one.

13
| username: TiDBer_小阿飞 | Original post link

Didn’t the author of Yearning say it was supported? Have you tested it?

14
| username: 托马斯滑板鞋 | Original post link

Yearning

15
| username: TiDBer_小阿飞 | Original post link

ALL, then there’s no problem.