Hourly Mysql backup
Posted by: Ivan Saez Scheihing
Date: December 25, 2016 04:57AM


I've a question about making Mysql backups and in case of a disaster loose at max 1 hour of activity.
My concrete question is: is it safe (performance wise) to execute every hour a 'fluhs-logs' command and rsync the the binary-logs files to an external backup device?
What could be the drawbacks of such a procedure?

I know about slave setups but the customer wants the backup to be kept externally.

Thanks in advance.



Options: ReplyQuote

Written By
Hourly Mysql backup
December 25, 2016 04:57AM
December 25, 2016 01:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.