I am looking to set up a new server. I can only use Intel 520 Series 240gb MLC ssds or standard Seagate 7200rpm disks.
These are the non negotiable options.
Naturally, as this is going to be running MySQL with its primary task being a MySQL server. As the biggest performance bottleneck being disk I/O, I would prefer to use the SSDs.
I need to have close to 1TB of disk space. Now, RAID5 does not give the best performance and is rumoured to not be best for SSDs, so I am looking at a Raid 10(1+0) setup which would give me 720gb (240gb * 3)
I need to know how I can set this up with Ubuntu 12.04.01 LTS using software raid and to make sure that TRIM support (Discard I think its called in Linux) is enabled for the raid config.
Has anyone don't this successfully? Any howto info and stuff to watch out for and basically what tools to use and so on would be of great assistance.
Ideally, I also need to be able to boot off the SSD raid array.
Can anyone point me in the right direction ?