When backing up a replication slave, which three should also be backed up in addition to data?
A.
The master.info and relay.info files
B.
The relay log files
C.
The relay index file
D.
Mysql.slave_master_info table
E.
Mysql.slave_relay_log_info table
F.
Mysql.slave_worker_info table
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-rawdata.html
A,B,C
http://dev.mysql.com/doc/refman/5.6/en/replication-solutions-backups-rawdata.html
Actually relay logs are not necessary.
“If you lose the relay logs but still have the relay-log.info file, you can check it to determine how far the SQL thread has executed in the master binary logs. Then you can use CHANGE MASTER TO with the MASTER_LOG_FILE and MASTER_LOG_POS options to tell the slave to re-read the binary logs from that point. This requires that the binary logs still exist on the master server.” – from your link.
I would say ADE. (but D, E depends on configuration and “mysql” database should be treated as “metadata”)
A, B, C.
It says ‘should’ have, not ‘must’ have.
Steve, I don’t see anything about the relay index file in the RM? maybe it should be A,B,E?
A, B, C.
A, B, C.
The other three are included in the “data”.