Checking Whether the ExpireLogsDays Value Is 0
MySQL Synchronization and Disaster Recovery
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.) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.