I am trying to purchase a new Server to run MySQL Server on. This new server will be a slave of my main machine. However, this server will be dedicated for reporting only "Lots of reads and complex queries."
Now I am looking into investing into solid state hard drives but was wondering if it really worth the price. The difference between SSD and a SATA 7200 hard drive is about $1500 and less desk space. If I do invest into SSD will the speed be noticeable?
I can purchase 4 (500GB SATA 7200) for $1500 less than purchasing 2(500GB SSD)
Can you please help me making the decision to see if it is worth the upgrade or not?
Once more thing that I would like to mention is that I am not using
query_cache so there will be lots of disk reads.
This server will have 32GB of RAM and will run