I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going Raid5(3+1) and Raid 1 (Mirrored) but that might a little overkill? Now, for the CPU, is a single 8core sufficient? what about Ram? 16gb? 32gb? This is going to have a lot of writes, fewer updates, and a lot of searching... the databases are about 2GB each, and they are monthly created (basically for storing stats). Typically, only the current, and past 2-3 months are accessed, and the others are just there for archival purposes.
My reasoning for going SSD over 15k drives was speed. The lookups would (should) be faster, or so I would think. What are your thoughts about this? is this a good idea? do you have better idea? The only thing on this server would be MySQL, the stats database, and a couple others that are used daily, but not nearly as active as the stats db. Thanks for any and all help! MV.
