I have a server with 2 harddisks, and it is used to host a site of mainly forums. I want to use both harddisks to minimize the IO load.
My sites are quite SQL intensive, and logfile builds up quite fast too (700M/day). There are very few mails. Backup is not a problem, I can keep a mirror data of each disk on the other and sync them daily.
I am thinking about:
Disk 1: OS + sites + mail + temp
Disk 2: MySQL + logs
But I am not sure if that's the best config. Please give me some suggestions.
How about creating a little two disk raid-0 array using the linux software raid tools, would that be an option? That would distribute the load pretty evenly over the 2 disks. If one disk dies, all the data is lost though so keep a backup too somewhere.
RAID0 combines two drives into one. If one drive fails, the whole thing dies.
This is what you want to do:
Use RAID1 in which, for example, you have two 80 GB hard drives. You have 80 GB usable space, but the IO is balanced between the two.
Use RAID5 in which, for example, you have three to five 80 GB hard drives. You have 160 GB usable space, but the IO is balanced over all drives on the array. If one drive fails, the array becomes RAID1.
If you're going to use RAID, I highly recommend getting a 3Ware RAID Controller. RAID is the BEST solution for IO balancing. On my database server, processing 500 queries per second and a few gigs of logs per day, I am using RAID5 with 3 hard drives at 10000RPM each.
Thank you all for your suggestions.
Unfortunately, RAID is not an option for me.
I just want to know, from your experience, what is the proportion of disk IO of database, home, tmp, swap, log, mail, OS... so that I can split the load evenly on 2 harddisks.