I am trying to create a backup strategy for my website. We are running the latest version of MariaDB and my plan was to use cron job every night to run a shell script that would run the backup using innobackupex wrapper. Then I would have the backups in my backup directory and I would also have another cron job that ran once a week that would export the backups to an off site server.
My first question is should I prepare these before they are sent out to the offsite server or should I prepare them on the external server? Second I would also only want to keep a weeks worth of backups is there any easy to remove old backups using a Shell script?