4 ms·
My point is that there are sanity checks built into the process. It's not difficult. There doesn't need to be a human verifying things there. Is the row count i
by scurvy 10y ago
My point is that there are sanity checks built into the process. It's not difficult. There doesn't need to be a human verifying things there. Is the row count increasing over the previous backup? Check. Is the checksum different? Check. Is it non-zero? Check. And on and on.
Stop making excuses and automate testing your backups.
- riffraff 10y agoso, when your check process does not report because it failed to run, how do you know? Do you have a monitor for your monitor? Does that monitor have a monitor? There is no reason not to automate your backup tests, but there is no reason not to eyeball the check is actually working from time to time.
- scurvy 10y agoYes, the restore process checks in daily; alarms are thrown if it doesn't check in. MySQL is also pretty good about not starting if the data is corrupted for whatever reason. The process not starting is a pretty obvious alarm, too. Checks are cheap. Better to automate your logic and invest in good monitoring and automation.