innobackupex backup process?

MySQL & MariaDB Percona XtraBackup
1

Hi.

Just wondering, I have been working with this beautiful piece of software, the doc is clear in how to do full backups for innodb tables.

I can follow the manual without issue, but my question is this one:

1; We create the backup.
2; Prepare the full backup.

Here, once u run the first step, u have to run the second one right away?

The answer will apply to differential && incremental to?

Thanks.

Centos 5.7 x86
v 1.6.3.

2

You can delay the second (prepare) step, but it’s not a good idea. It makes your backup slower to restore because you have to do more work when you need the backup. And if something is wrong with it (or if there is a bug in xtrabackup) you want to find that out NOW, not when you need the backup.

3

Hi xaprb.

Good, if is better to run the 2nd step but will be slower I prefer to do it, at night we are not using the DB is went I run my backups I can wait.

Thanks xaprb.