News for hackers. Stuff that matters.

A comment on Neon – Serverless Postgres. Parent comment

Re:Neon – Serverless Postgres by szundi on Saturday May 28, 2022 @10:20AM (#31540528)
Maybe that zfs snaphot under a running database? Is that ok?
[ Parent | on HN ]
Re:Neon – Serverless Postgres by alduin32 on Saturday May 28, 2022 @12:06PM (#31541407)
Yes, ZFS snapshots are atomic, so as long as the database use sane semantics to do disk I/O, you're fine (AFAIK, PostgreSQL and MySQL/InnoDB are ok, MySQL/MyISAM is not though).

A snapshot is effectively identical to a killed database server (due to OOM, or power outage), and database servers should be crash-resistant.

With PostgreSQL, checkpointing the database before taking the snapshot may make the crash recovery quicker when loading the snapshotted database.

[ Parent | on HN ]