Re: [CentOS] C8 and backup solution

On Fri, Apr 3, 2020 at 6:58 AM Chris Adams linux@cmadams.net wrote:

It isn't just databases - there are other things that backing up individual files one at a time is not so good. The best way to handle that is to freeze/snapshot the whole filesystem, and then back up the snapshot. This can be scripted pretty easily if the filesystem is on LVM.

I tried this with a fairly busy and rather large database server (ok, it was a database server running a simulation of a production workload) and LVM (with either ext4 or xfs) and found LVM snapshots to be completely unworkable under busy 8K block random write workloads

now, ZFS does snapshots very nicely