MySQL Forums
Forum List  »  Backup

Re: best way to backup data
Posted by: Rick James
Date: December 17, 2014 11:48AM

When someone talks about 100% perfection, I reach for my pessimist's hat...

Well, I'm saying that nothing is 100%. Are you protected against flood, earthquake, tornado, etc?

> Why do you said to pull a dump out of evault to a different computer?

* For all you know, Evault has a fatal flaw.
* Or your machine that is flawed, and testing the backup with a different machine would discover that flaw.

How many backups do you "keep"? If you keep only one in Evault, then "Murphy's law" states that Evault will crash while you are replacing your one backup.

The exit code from mysqldump cannot say whether the data is correctly saved, it can only say that the process seemed to finish correctly.

Do you have protection from the cronjob failing to run? From it failing to start? Etc, etc.

The best test is an end-to-end test (hence, loading onto a separate machine and testing that). But even that does not cover all the things that _could_ go wrong.

You are doing a good job. Don't dwell on this too long; move on to other problems to solve.

Options: ReplyQuote


Subject
Views
Written By
Posted
3092
December 11, 2014 01:36PM
1847
December 12, 2014 11:01PM
1645
December 15, 2014 08:59AM
Re: best way to backup data
2125
December 17, 2014 11:48AM
1420
December 17, 2014 01:20PM


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.