search

gstorme / autoxtrabackup

Scheduled MySQL (full & incremental) backups with Percona innobackupex / xtrabackup
MIT License
43 stars 36 forks source link

Incremental backups always use last full backup as base instead last incremental backup #1

Open dorogarcia opened 9 years ago

dorogarcia commented 9 years ago

Hello,

Every time script creates an incremental backup, it use last full backup as base, so you are duplicating a lot of incremental backups.

May be it is not wrong, so my question is:

Are you doing it because you prefer duplicate data, but have last hot incremental ready to restore?

Another solution is create a incremental for last incremental, it will save resources but if you have 23 incremental and number 8 fails, you can not restore after that. If you have small dbs it's ok, but if you have big dbs with intensive IO and create an incremental backup every hour, backup 20,21 and 23 (for example) takes similar time than full backup.

Thanks.

Best Regards.

jianhaiqing commented 6 years ago

I think it's a good strategy, that you don't need to use many incremental backups to restore the backup,then it saves hours. But on the other side, it takes more hard disk spaces.

dorogarcia commented 6 years ago

Ok. It's assumable if database is not too big.