Mysql HDD vs SSD

[Niklas]

I tried using a HDD for inserting a good amount of data and then compared to using a SSD / NVMe and the results are great, the ssd/nvme outperforms HDD big time, but is it possible to have a HDD drive and still get the same results, perhaps by using RAM?

I got innodb but from what I understood, RAM mysql performance is only for read / select but not for insertion?

[kufthz]

If it's a mission critical MySQL/mariaDB database deployment get enterprise class NVMe drives or at the very least enterprise class SSDs, preferably in RAID 10.

PCIe Gen4 NVMe drives can deliver great performance for DB applications.