Does the binlog log exist?

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

Original topic: binlog日志是否存在

| username: TiDBer_Jpn7WkR4

[TiDB Usage Environment] Production Environment / Testing / PoC
On Linux system
[TiDB Version]
Version 6.5.2
[Encountered Problem: Problem Phenomenon and Impact]
Executing SHOW VARIABLES LIKE ‘log_bin’; shows that logging is not enabled, but executing SHOW MASTER STATUS; shows that logs exist.
MySQL [(none)]> SHOW VARIABLES LIKE ‘log_bin’;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| log_bin | OFF |
±--------------±------+
1 row in set (0.010 sec)

MySQL [(none)]> SHOW MASTER STATUS;
±------------±-------------------±-------------±-----------------±------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
±------------±-------------------±-------------±-----------------±------------------+
| tidb-binlog | 444855438723776513 | | | |
±------------±-------------------±-------------±-----------------±------------------+
1 row in set (0.002 sec)

[Resource Configuration]
TiDB is a cluster, TiKV is on three servers, but there is no log-related configuration found in the tikv.toml files on these three servers.
So I want to know if the logs shown by SHOW MASTER STATUS; actually exist.
[Attachment: Screenshot/Log/Monitoring]

| username: Fly-bird | Original post link

The binlog is in the off state, so the log should not exist.

| username: 路在何chu | Original post link

You need to configure the binlog server to have logs.

| username: TiDBer_Jpn7WkR4 | Original post link

Is it possible to recover accidentally deleted data through other means if there is no backup?

| username: TiDBer_Jpn7WkR4 | Original post link

Is it possible to recover accidentally deleted data through other means without a backup?

| username: 像风一样的男子 | Original post link

During the GC time, you can use the FLASHBACK TABLE statement to restore tables and data that have been deleted by DROP or TRUNCATE.

| username: zhanggame1 | Original post link

The default is not enabled.

| username: Soysauce520 | Original post link

Use show config to view the configuration.

| username: tidb菜鸟一只 | Original post link

Depending on the duration set for your GC, if it’s long enough, you can still recover using the flashback method or by setting tidb_snapshot.

| username: xingzhenxiang | Original post link

The default is not enabled.

| username: TiDBer_小阿飞 | Original post link

It’s not enabled by default, right?

| username: heiwandou | Original post link

The binlog should be on the TiDB pump node, right?