Which server to choose for MySQL?

Question

linux

I select a server for the MysSql database Load
structure
select 71.22%
insert 13.88%
set option 10.45%
update 1.93%
show fields 1.23%
replace 0.79%
The amount of data grows, so the place is simple
Option 1) 100 euros per month
Intel® Xeon® E3-1270 v3+ 2 x 480 GB SSD(RAID1) + 32GB ram
when it runs out to take another such server, then another one (data can be sharded).
Option 2) €276/month
Intel® Xeon® E5-1650 v2 Hexa-Core + 3 x 480 GB 6 Gb/s SSD(RAID 5) + 128GB RAM
Option 3) €315/month
Intel® Xeon® E5-1650 v2 Hexa-Core + 4 x 480 GB 6 Gb / s SSD (RAID 10) + 128GB RAM
and forget about servers "longer"

Answer 1

Perhaps you should look towards PostgreSQL (according to experience - more productive), and then think about switching to NoSQL technology, if, of course, unstructured storage suits you.
In general, look at the topics of high loads, horizontal parallelization, sharding, and generally strain programmers for optimization and caching (as you know, changing the O (n ^ 3) algorithm to O (n log n) saves money)

Answer 2

I would advise looking towards AWS. If you take a car in the cloud, then it can be expanded very much. AWS measures computing power in ECUs. 1 ECU is about 1 - 1.2 Ghz. So in the car there can be up to 32. This is equal to about 2 x Xeon® E5-1650.
In a nutshell, you can adjust the disk speed from 100 IO to 20,000 IO. For example, 100 is the work of a standard HDD 7300 rpm. But MySQL doesn't necessarily have a fast drive to data tables. You can simply specify a fast disk path to the cache, so that it can be quickly read from the cache.
In addition, you can configure something like load distribution. Narpimer from 7 am to 6 pm, one server is average. After 6 to 12 at night, one large one will be connected, and then it will switch to a small one.
Or let's say you have a special day coming up. The release of a new product and you expect hundreds of thousands of people that day. You can increase the power of servers only for one day. Pay only for that day. Very comfortably.
In addition, AWS has a relational database service that supports MySQL. It's like just a base on the service from AWS. You only get connection data for root. And you can do whatever you want with it. And adjust the power as you want.
I agree that perhaps AWS is more expensive than other possible options. But the quality of service is unparalleled.

Answer 3

Since you have most of the load on reading and fetching, the main critical parameter will be the amount of RAM, so from your options I would advise Intel® Xeon® E5-1650 v2 Hexa-Core + 3 x 480 GB 6 Gb / s SSD (RAID 5) + 128GB RAM, if the raid controller has the ability to use the SSD disk as a cache in hardware, then this will also greatly increase the performance of the entire disk.

Answer 4

The query structure is great. How many requests per second do you have? Based on this, you need to select a processor and RAM. And if the main thing is the amount of data, then why SSD drives? Perhaps ordinary SATA will suffice, but a volume of several gigabytes is not a problem.