Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.