News for hackers. Stuff that matters.

A comment on I took all my projects off the cloud, saving thousands of dollars. Parent comment

Re:I took all my projects off the cloud, saving thousands of... by ngc248 on Wednesday November 05, 2025 @12:35AM (#45819578)
nah filesystem snapshots may not lead to consistent DB backups. DB backup software usually use a plugin to tell the DB to coalesce data before taking a snapshot.
[ Parent | on HN ]
Re:I took all my projects off the cloud, saving thousands of... by enronmusk on Wednesday November 05, 2025 @03:44AM (#45820814)
> filesystem snapshots may not lead to consistent DB backups

Only if your database files are split across multiple file systems, which is atypical.

[ Parent | on HN ]
Re:I took all my projects off the cloud, saving thousands of... by Dylan16807 on Wednesday November 05, 2025 @03:08AM (#45820584)
Databases have to be ready for power loss, don't they? They might not be happy about it, but if that corrupts anything then the design has failed.

And again I'll emphasize proper snapshot, cutting off writes at an exact point in time. A normal file copy cannot safely back up an active database.

[ Parent | on HN ]
Re:I took all my projects off the cloud, saving thousands of... by baq on Wednesday November 05, 2025 @02:07AM (#45820179)
At least one OS you’ve heard of can quiesce the file system to allow taking a consistent snapshot; I’d be surprised if this wasn’t widely available everywhere.
[ Parent | on HN ]