I have a Samsung 970 EVO Plus NVMe M.2 1TB (PCIe 3.0) SSD. The SSD has a TBW of 650.
Now, obviously the SSD is way faster than the HDD. But, as we all must know: the SSD has a limited write endurance
, but the HDD does not have a limited read/write endurance.
I am using Linux.
My server has a MySQL database which most of the time performs
UPDATE commands, for example: 2-3 of these commands per minute, depending on the usage of the website. And all the others are
SELECT commands, probably: 50 times per minute.
And, I constantly compile, and create programs in the same machine, i.e.
rm -rf /usr/local/installedprogramfolder, and repeat the same many times a day, probably about 500 times a day.
Due to the above, I think compiling and creating programs, removing then repeating the same is not so good for the TBW of the SSD. But, The hard drive is slower than the SSD, resulting in less work done in a day, i.e. lower efficiency.
And the above ^ is where I am unable to decide if I need to use the SSD or the HDD!
Yes, this question might need answers based on opinion, but, still, I have narrowed it as much as possible.
I could go with an Enterprise SSD, but my budget is under Indian Rupees. 20,000 (about 275 USD), and the current SSD would just go to waste unless I assign a specific use to it.
The stuff inside the server is very confidential. Passwords and chat messages in the MySQL database. But, the stuff are encrypted. A remote backup wouldn't be really good for privacy in terms of this I believe; I keep backups in multiple External 3 TB drives.
Someone suggested me to use RAID, to combine multiple drives.
I will try that trick later, when I buy another HDD. Maybe in a few weeks. Sorry.
Surely, someday, I will have the money to keep buying these SSDs, but not today though.
Btw, now, I have understood that HDDs are also a victim of wear I forgot that HDDs wear down because of the spinning disc inside of it.