How to turn on relay_log_recovery

This article shows you how to turn on relay_log_recovery. It is concise and easy to understand. It will definitely make your eyes shine. I hope you can gain something from the detailed introduction of this article.

When the slave goes down, if the relay-log is damaged, resulting in some relay logs not being processed, all unexecuted relay-logs will be automatically discarded and logs will be retrieved from the master again, thus ensuring the integrity of the relay-log. By default, this function is off. When relay_log_recovery is set to 1, this function can be enabled on slave slave library. It is recommended to enable it.

mysql> set global relay_log_recovery=1;

The above is how to turn on relay_log_recovery. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserves, please pay attention to the industry information channel.