Oct 15, 2026, 6:41 AM@mwl any particular reason to have /var/mysql, assuming that's the DB dir, on zfs?
- Oct 15, 2026, 6:41 AM
Replies
Oct 15, 2026, 12:32 PM@kaveman definitely put your database on ZFS!
Adjust recordsize to match the db block size, select the caching to match what your database doesn't optimize for, plus free snapshots and replication etc.
- Oct 15, 2026, 12:49 PM
@mwl interesting! I'd still hesitate to replicate because of WAL files etc.it would be safer to delegate to the db engine for replication. I think.
- Oct 15, 2026, 12:53 PM
@kaveman seriously, do both. Live replication in the cluster, zfs snapshots & replication for backups & DR
- Oct 15, 2026, 6:56 PM
@mwl I'll keep that in mind. The hesitation comes from potential write amplification but then again haven't managed heavy-workload databases in 20 years so I'll take your word.
- Oct 15, 2026, 7:43 PM
@kaveman you can absolutely cause write amplification through misconfiguration!
But if you tune it correctly, it's screaming fast