Mariabackup and prepare strategy

MySQL & MariaDB
1

I have a script that uses mariabackup to backup my data no options were used in the script. I found out that after the backup the script doesn’t do PREPARE!. I know this can be done after the backup and during recovery process.

To prevent data corruption do I need to involve the prepare in the script or can I still do it during the restore. My question is this a good practice? What’s a good practice?

2

Hi, the benefit of doing the prepare phase right after the backup finishes is that restore will be faster. You simply move back the files and start MariaDB. However you lose the ability to apply incremental backups on top of the full backup. So really there’s no best practice here, just a tradeoff.

1 Like