Since 2016, I’ve had a fileserver mostly just for backups. System is on 1 drive, RAID6 for files, and semi-annual cold backup.

I was playing with Photoprism, and their docs say “we recommend placing the storage folder on a local SSD drive for best performance.” In this case, the storage folder holds basically everything but the pictures themselves such as the database files.

Up until now, if I lost any database files, it was just a matter of rebuilding them by re-indexing my photos or whatever, but I’m looking for something more robust since I’ll have some friends/family using Pixelfed, Matrix, etc.

So my question is: Is it a valid strategy to keep database files on the SSD with some kind of nightly backup to RAID, or should I just store the whole lot on the RAID from the get go? Or does it even matter if all of these databases can fit in RAM anyway?

edit: I’m just now learning of ZFS caching which might be my answer.

  • ch00f@lemmy.worldOP
    link
    fedilink
    English
    arrow-up
    2
    ·
    14 hours ago

    Hm… My new motherboard does actually have dual NVME M.2 slots. I might end up doing that (once my budget recovers a bit).

    • haui@lemmy.giftedmc.com
      link
      fedilink
      English
      arrow-up
      1
      ·
      13 hours ago

      You dont even need special nvme‘s. You can buy mid range ones.

      Best is if they dont fail together so they should best not be the same batch or have the same age and write amount.

      I do highly recommend to have a raid array for any server ssd since they fail unpredicably and without any signs.