I'll be running ubuntu server on a 3 disks server (450 GB each) and 16 GBs of RAM.
My target at the moment isn't configuting MySQL itself, but what could be the best RAID configuration for my case here (Top priority is for system availability\data-protection and then comes performance, the disks are pretty fast anyway).
I've been reading for a while about partitioning and I'm thinking about doing the following:
- I'll have different partitions for /boot, /, swap, /home and /db (holding all mysql files). This schema is for no particular reason other than separating each aspect of the OS from the other so no partition would steal space from other critical partitions.
But I have no idea what file system should I use for each partition ? Is it ok to have different file systems for each partition ? Are their recommended ones for /boot, / ? For MySQL, I'm not sure yet, it's debates everywhere ! I only need something stable and easy to handle. I'm pretty sure these disks speed will do just fine for our needs and the partition size will hardly be an issue
Will use RAID 0 for swap partitions, RAID 1 for the /boot partition and RAID 10 for the rest. I only have 3 disks and my main concern is the reading throughput (database reports), not the writing throughput, and of course system availability.
Use RAID 5 because I only have 3 disks and my main concern is the reading throughput (reports), not the writing throughput. But I'm not sure how to configure a RAID array. I've followed ubuntu's server partitioning guide and I was confused by only having 2 partitions, one for swap and one for /. While the one for swap is bootable and used as "physical volume for RAID", why is that ? And what does "physical volume for RAID" mean ?
What would be a recommended swap space if the RAM is 16 GB ? I say 4 GB, just to reduce the I/O blocking. What do you think ?
Any suggestions are mostly welcomed.