So I'm implementing a backup strategy for our project and came across some text which I need absolute clarification, false positives are the death nell of IT.
I am looking to do your typical backup strategy, weekly full back-up with daily incremental backups. Here's the rub:
According to the docs, when doing a full backup you have to 'prep' it, which is to run all uncommitted transactions etc. You can prep the backup by using the innobackupex --apply-log /path/to/BACKUP-DIR command.
But according to these docs, if you do an incremental backup, you have to 'prep' it differently, using the innobackupex --apply-log --redo-only BASE-DIR command.
My plan is to write a cronjob to do a full backup on Sunday @ 12:01am, and an incremental on M-Sa @ 12:01 am. So my question is, should the cronjob prep every backup with the --redo-only flag, to ensure that full backup can be merged with following incremental backups?