Description:
The manual entry for --relay-log-recovery says:
"To provide a crash-proof slave, this option must be enabled (set to 1), and --relay-log-info-repository must be set to TABLE. See Crash-safe replication, for more information."
http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#option_mysqld_relay-...
When reading "Crash-safe replication", that page says:
"In order for replication to be crash-safe when using tables for logging status and relay information, these tables must use a transactional storage engine, such as InnoDB. Beginning with MySQL 5.6.6, these tables are created using InnoDB. (Bug #13538891)
Therefore, in order to guarantee crash safety on the slave, you must run the slave with --relay-log-recovery enabled, in addition to setting --relay-log-info-repository to TABLE."
http://dev.mysql.com/doc/refman/5.6/en/slave-logs.html#replication-implementation-crash-sa...
The latter makes it sound like *if* you use TABLE, in order to make that crash-safe, the tables need to be InnoDB.
As I understand it, *one* way for crash safe replication is to use --relay-log-recovery=1 + --relay-log-info-repository=TABLE (and ensure the table is InnoDB), but *another* (at least from reading http://bugs.mysql.com/bug.php?id=68281 ) is to use relay-log-recovery=1 + sync-relay-log=1.
If the latter is not an option, then I guess nothing needs added/changed. However, if it is accurate, then I think a couple of updates would help a great deal.
Note there is a similar message for --relay-log-info-repository, so if it should be updated above, then it should also be updated here.
http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#option_mysqld_relay-...
How to repeat:
N/A
Suggested fix:
N/A
