3 ms·
Maybe that zfs snaphot under a running database? Is that ok?
by szundi 4y ago
Maybe that zfs snaphot under a running database? Is that ok?
- alduin32 4y agoYes, 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.