Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
@Aldar
Backup a database using LVM only seems like a __bad__ idea.
BTRFS is afaik CoW. As such - usage > 80 % - performance bye bye.
I think BTRFS has become better, at least when you don't use RAID mode.
I'd choose LVM over BTRFS - simply because LVM isn't a filesystem.
I dislike complex filesystems for a simple reason: because they're complex.
There are myriads of combinations which might lead to problems - mostly bound to specific kernel versions.
I don't hate ZFS or BTRFS - but I wouldn't run a database on it.
Coming back to first statement: using only LVM / FS snapshots is a bad idea... Since there are running transactions and you end up with an unclean backup in most cases.
Most databases provide an backup / read lock, when used in tandem you can be sure that the backup is clean.
Another reason I'd stay away from CoW filesystems is the fragmentation issue and possible lock contention.
LVM might be slower (depending on configuration/type) than BTRFS, but you'll have fewer nightmares and especially less maintenance work. -
Aldar12044y@IntrusionCM I simplified just so that I did not have to describe it all. Yes, I am aware that a simple snapshot and of a running DB is a terrible idea and the days would never be consistent.
When doing such backup, I flush all tables with a readlock, then create the snapshot and release the lock. That way data is always consistent.
And finally mount the snapshot and back its contents up, then remove it, keeping the snapshot around would just lead into it filling up and invalidating. -
Aldar12044y@nitwhiz and? I never found LVM difficult to manage. Maybe I never had to do anything complex, sure, but volume management, snapshotting, partitioning and such... Its... Simple, really. Mind elaborating?
-
Aldar12044y@sbiewald never said that they do. Just feel that... Its a tad pointless to learn both when in the end, one would end up using the same set of features. Its better to learn using one more over the other.
Related Rants
-
hubofeverything2After several long nights of learning to resize encrypted lvm partitions, fixing grub, finding screws, and wai...
-
Jabster282man i wish i had brain cells. i was trying to free some storage by deleting some btrfs snapshots, so i mounte...
-
nightowl3Linux software RAID and LVM are pretty powerful. Bought a new server case for my home file server / VM host. ...
So... I've been thinking, I tend to default to LVM when trying to create easy-to-manage disk partitions, or when I want to backup a database without long lockings during a dump... Though, now... I got thinking.
What do you guys think, which is better in terms of functionality: BtrFS or LVM?
I know BtrFS offers such thing like full snapshots that allow to easily transfer just the increment over the snapshot origin off to a remote server for archival, but I never fully grew to trust btrfs as a server filesystem... Its...
Younger, and not as widespread, not to mention I don't know any performance statistics to recommend its use for this or that case (Like... Would a high-load database engine stutter flushing all those changes on disk while reading / writing temp tables and such)
question
lvm
which is better
btrfs