Mysql Percona XtraDB cluster Backup

[faisalmali]

Dear Community,

Seeking some feedback and clarification.

I have A Cluster running Mysql Percona XtraDB which comes with its own tool to preform backups so I have a script to run the backup on the server it self.

sudo xtrabackup --backup --user=root --password="xxxxxxxxxxxxxxxxx" --encrypt=AES256 --encrypt-key="xxxxxxxxxxxxxx" --compress --target-dir=${NEW_BACKUP_DIR}

So I understand Veeam VBR does not support clustered Databases but I understand I can add a post script to my backup job to run so my question us if I add the script to be ran by veeam what is the outcome will the backup be stored in the server it self? I jjust want to understand how exactly it works.

Thank you

[PetrM]

Hi Faisal,

It will be stored in the directory specified by the --target-dir parameter. The only responsibility of our job is to run the script itselfб our job does not control or change the content of these scripts.

Additionally, if the target directory is on the local server, I would recommend running the command above in the pre-job script to back up the server with the newly created application backup.

Thanks!