[viceCoolMan]

I bought an HDD a while ago and want a new storage device to store databases. Now that I have some credits, I want a reliable storage device. My goal is to be able to search them all simultaneously. I'll need to sort them first, but with that level of data, I want a RAID setup, I just don't know if I should use SSD or HDD in that configuration. Do you have any suggestions?

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Self-Ban | http://c66go4clkqodr7tdjfu76jztjs7w7d3fajdeypxn73v4ju3dt7g5yyyd.onion/Forum-Ban-Appeals if you wish to be unbanned in the future.

[titohippie]

Hi viceCoolMan.

For my part, I would like to recommend you use SSD disks given its higher transfer speed.
About raid:  I would like to recommend you (at least initially) use 2 SSD to create aRaid 0.
The problem is that only one disk crash you will lose al data, but the principal advantage is that the transfer speed will be increase with this.

[joepa]

wait for this one https://nascompares.com/2025/01/08/minis...-revealed/

[Boat]

If you’re dealing with large databases and want fast searches, SSDs are the way to go—specifically NVMe if your budget allows. HDDs are fine for archival storage, but they’ll bottleneck searches, even in a RAID array. For a solid RAID setup, go with RAID 10 for redundancy and speed, or RAID 5 if you want a balance of storage efficiency and fault tolerance. If your data is critical, consider enterprise-grade SSDs with power-loss protection (e.g., Samsung PM983 or Intel P4510). Also, if you’re indexing and querying across multiple datasets, using a ZFS-based file system with L2ARC caching can optimize search speeds. For serious parallel searching, pair the RAID with a dedicated storage server (Unraid or TrueNAS Scale) and run a distributed query system like Elasticsearch. Also, dont forget full-disk encryption, and if you're working with v imp datasets, consider self-encrypting drives (SEDs).

[joepa]

Dor searching, SSD would be way faster. But also more expensive. And smaller volumes. So I guess it's large HDD of RAID NVME to get to decent capacity.

[Unknown_Boy]

Avoid mixing SSD and HDD in one RAID

Remember: don't use RAID 0