TiDB-binlog Issues

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

Original topic: TiDB-binlog问题

| username: TiDBer_CkS2lbTx

Does TiDB have a feature like MySQL where you can enable binlog and use third-party tools like my2sql to generate SQL for flashback actions?

| username: TiDBer_jYQINSnf | Original post link

You can refer to this: TiDB 日志备份与 PITR 使用指南 | PingCAP 文档中心

| username: DBAER | Original post link

Just use flashback, it will work.

| username: WinterLiu | Original post link

Isn’t there native flashback? But the premise is that it hasn’t been garbage collected.

| username: xingzhenxiang | Original post link

| username: TiDBer_CkS2lbTx | Original post link

MVCC’s multi-version is in the form of insert into, right?

| username: WalterWj | Original post link

  1. The new version of binlog is about to be deprecated.
  2. Binlog has a pb mode, and Reparo is used for recovery.
| username: dba远航 | Original post link

TiDB has a dedicated flashback operation. For details, refer to the video training. At the same time, it requires the cooperation of GC parameters.

| username: Soysauce520 | Original post link

Within the GC time, you can directly flashback. Outside the GC time, there are PITR and binlog. In version 7.5, it is recommended to use PITR.

| username: 小于同学 | Original post link

Flashback

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.