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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot