MySQL database server specification for a website?

Question

linux

I select the new server for a DB. I would like to know your opinion and recommendations.
Initial data:
the database serves the site with 100-200 requests per second. (growth up to 200-250)
Now the load is 1000 - 2000 requests per second (I keep in mind growth up to 3-4k)
DB size - 63 Gb (growth up to 100Gb)
Disks: 4 disks 2Gb each, RAID 1 is made for the database on two disks
Memory: 32 Gb
CPU: Intel Quad-Core Xeon E3-1270 (4 cores, 3400Mhz)
MySQL 5.5 database over Centos 6.4
What I want:
Need a server that can satisfy requests over the next year, I expect a load increase of 20-50%. Definitely going to increase the memory to 64Gb. Otherwise, it is not clear whether to switch to SSD or stay on disks? Should I get a more powerful CPU?

Answer 1

I advise you to take not 64, but 128GB (at least) of RAM and a processor with the maximum number of cores (6-core with HT is a very worthy option). Because you didn’t write about the disks in great detail, it’s not clear what you have SAS or SATA. If SATA, then change to SAS 10k (or 15k if the budget allows), if SAS, then you can leave it as it is. RAID 1+0 or RAID 5 of all 4 drives would be great.

Answer 2

Loading in the form of abstract requests per second does not allow us to draw any conclusions about the load on the disk subsystem.
If you upgrade the disk, then only on ssd. When using ssd 32G of memory with a 100G base, I think it will be enough (the simplest memory approach - all actively used indexes should fit into it).