Bug #90935 Modify relay_log_recovery Documentation
Submitted: 18 May 18:33 Modified: 21 Aug 23:42
Reporter: Juan Arruti Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any

[18 May 18:33] Juan Arruti
Description:
Since MySQL 5.7 onwards does not need to enable relay_log_recovery to guarantee recovery, please change documentation to reflect this change for versions 5.7 and 8.0 where it states the following:

When using GTIDs and MASTER_AUTO_POSITION, set relay_log_recovery=1. With this configuration the setting of relay_log_info_repository and other variables does not impact on recovery. 

Please find below the links to MySQL documentation to be updated:

https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-slave-halt.html
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-slave-halt.html

Many thanks

How to repeat:
N/A
[20 Aug 21:26] Jean-François Gagné
The statement in the description of this bug is false.  It is not true that "since MySQL 5.7 onwards does not need to enable relay_log_recovery to guarantee recovery".  So the documentation bug is about implying that relay_log_recovery is not needed.

I have reported this in Bug#92093 with an example where recovery fails without relay_log_recovery.
[21 Aug 14:37] Bogdan Kecman
Hi,
I'm verifying that in combination with Bug#92093 this is wrong. So both bugs should be worked on together.

thanks
Bogdan
[21 Aug 23:42] Juan Arruti
Hi Jean-Franç, Bogdan:

Thanks for your inputs. Since same page for MySQL 5.6 documentation does not show this issue, the intention of this bug was to report the contradiction between the chart, showing relay_log_recovery can be ANY to make the slave as crash safe, and the immediate paragraph below to the chart in the documentation, in order to review them. Since Jean-Franç already has a test case which shows relay_log_recovery is needed for a crash safe slave, the issue seems to be in the chart and not in the paragraph, showing the same as MySQL 5.6 documentation.

Many thanks.
JP