Re: mysql 5.5 mysqldump

[Shiva V]

Hmmm, 20 views & still no answer. Is this a naive question?

I forgot to mention that the SQL thread on Slave deletes the "Relay Log Files" automatically whenever it rotates the relay log files (either with flush or max size reached). So, in essence, the relay log files do not stay there for "n" amount of days to consider them as "Incremental backups".

mysqlbinlog does read both "Bin logs" and "relay log files" in the same way. Both of these log files are formatted in the same way with respect to events logging, so i think these can be used for recovery purpose but not exactly true as there is no way to control the relay log files deletion and hence not used for "incremental backup strategy".

So, does this mean, that even though we take backups on SLAVE server, we still have to backup the "BINARY LOGS" on the MASTER server to implement a "Incremental backup" strategy? Or enable the "--log-slave-updates" to backup the "BINARY LOGS" on the SLAVE?

Thanks,
Shiva