I am setting up a physical server for an application that we have developed, the purpose of this server is to run the server's own software and store its database (mongodb).
On the server machine we want to configure a RAID 1 storage system to keep the information safe, but we do not know what would be better for this, whether to use SSD or HDD.
We have many questions about it such as
Will the performance improvement when using SSD be noticeable or is HDD enough?
Will SSDs have the same endurance as HDDs to be running 24-7?
Would the combined use of RAID 0 + RAID 1 with HDD be a better option than SSD?
I don't know if someone could help me solve some of these doubts or give me some kind of information or help in this regard.