Updated on 2024-11-30 GMT+08:00

Checking Whether the ExpireLogsDays Value Is 0

In MySQL synchronization and DR scenarios, if the value of expire_logs_days is 0, the task may fail.

Failure Cause

If expire_logs_days is set to 0 in the source database, operations such as startup and flush logs will trigger binlog clearance and result in a task failure.

Handling Suggestion

Run the following command on the source database to set the binlog retention period: In the following command, value indicates the binlog retention period. The value is an integer greater than 0.

set global expire_logs_days=value