I would like to setup a backup center to store all the backup sets of 3 mysql databases. My policy is doing 1 full backup one week and incremental backup every other days in this week. All the backup sets will be compressed and encrypted. The backup sets will be sent to the backup center after finishing backup without leaving a copy at local.
I would like to choose xtrabackup to do this. But after doing the research, I found that the incremental backup is based on the full backup. Since the full backup already sent to the remote server, how can I resolve this issue? I appreciate if anyone can give a solution.
I would like to choose --stream=tar and using gzip to do compressing work.