Hi,
I have no clue but I became curious, and found out that Mariabackup (the
fork of XtraBackup for MariaDB) can do partial backups:
https://mariadb.com/kb/en/partial-backup-and-restore-with-mariabackup/
KR, Eric
On 17/10/2021 04:34, billy noah wrote:
> Hey Alvin,
>
> Yes I've looked in to
Hey Alvin,
Yes I've looked in to this. The problem with Percona XtraBackup
incremental backups as I understand it, is that it's all or nothing in
terms of schema. The incremental backup option is great but it backs up
everything - and you'd therefore lose the ability to easily restore one
Have you thought about using the Percona XtraBackup or one of its
derivatives?
It has the advantage of being able to take a live database backup
without having to lock everything for potentially a long time.
It also has the ability to do incremental backups.
The backup is stored as a
Hi,
using e.g. --compare-dest you could use the backup directory from the day
before to speed up transfer, the file would be stored each time full, but the
speed should be higher.
KR, Eric (with c not k)
On 16 October 2021 12:53:30 UTC, billy noah wrote:
>Hello Erik and Dominic. Thanks very
Hello Erik and Dominic. Thanks very much for the suggestions. I'll most
likely try the 4 directory rotation suggestion. That was my first idea as
well but thought there might be a simpler way.
Dominic - restoring from these is something relatively frequent (2 - 3
times per month) and is often
Hello again,
and to add to this, if you're really only making a backup of one single huge
file, you might not need the overhead of rdiff-backup and could live with the
simpler and slicker rsync.
KR, Eric
On 16 October 2021 07:26:19 UTC, Dominic Raferd wrote:
>You could try using rdiff-backup
You could try using rdiff-backup --no-compression (or
--no-compression-regexp). This will make backups bigger but should speed
up backups and restores.
The only built-in compression offered by rdiff-backup is gzip, but if
you run rdiff-backup --no-compression to a file system using
Hi,
there is indeed no way out of the box to do this.
The simplest way to realize this would be to create a new backup repository
each week, it would then always have one snapshot and 6 deltas. Keeping the 4
youngest repositories, you would have reached your goal.
Hope this helps,
Eric
On 13