On Fri, Apr 3, 2020 at 6:58 AM Chris Adams <linux at 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 -- -john r pierce recycling used bits in santa cruz