I am looking for feedback on setting up a new pair of servers. I will be running a pair of machines, using DRBD failover, and pacemaker.
The machines they are replacing have the following usage patterns:
- They generate about 2 Gb binary logs per day.
- About 3 MB/s of data leaves the network cards
- About 0.4 MB/s arrives on the network cards
- About 800 select/sec
- About 180 Update/sec
- Innodb tables currently take up about 100G
With those stats in mind, what would be the best way of setting up the hard drives (There are 8 300Gb drives per server). I am leaning towards
2x 300Gb (Raid 1) for OS
2x 300Gb (Raid 1) for binlogs
2x 300Gb (Raid 1) for data
2x 300Gb as hot spare
The binlogs and data would be mirrored via drbd
My issue with this is that out of 16 300 Gb drives, I end up with 300Gb usable storage for the database.
Alternatively, I could go with
2x 300Gb (Raid 1) for OS and binlogs
4x 300Gb (Raid 10) for data
2x 300Gb as hot spare (or add them above to have 6 drive raid 10 for data with no hot spare)