How to choose the right machine for mysql(MariaDB) server?
Good afternoon, the question arose of choosing a machine for databases to mysql server (MariaDB last stable)
The size of all databases in the order of 30GB, and is slowly growing, Araunah data is almost there, the base is actively used.
there are 3 databases with MyISAM tables (1.5 GB) mostly reading, recording time for these tables is not important (and most of the time everything is unloaded into memory)
The rest of the tables in the database InnoDB
On the servers in addition to databases to twist something is not planned, possible, only, InfluxDB (20-30GB) - but it is possible
I'm interested in one of the important issues is the CPU, more Hertz or more cores(threads)?
Comfortable RAM (all our servers have a minimum of 64GB)?
Drives we SSDшные in soft raid (hard raid or better?)?