Updated on 2022-09-21 GMT+08:00

Checking Whether the ExpireLogsDays Value Is 0

MySQL Synchronization and Disaster Recovery

Table 1 Checking whether the expirelogsdays value is 0

Check Item

Whether the expirelogsdays value is 0

Description

If the expire_logs_days value of the source database is set to 0, the migration may fail.

Failure Cause and Handling Suggestion

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 migration failure.

Handling suggestion: Set the binlog storage duration by running the following command on the client: set global expire_logs_days=value (value indicates an integer greater than 0.)