We are looking at buying a new database server and I would like to know the best raid setup to use. I have read rad 1 for the os, another raid 1 for the logs and a raid 10 for the database.
Cost is always a concern so to curb costs I will either needs to do 1 raid 5 or 1 raid 10. The OS/Database/ and logs would all be on the chosen raid.
So is 1 raid 10 better than 1 raid 5 with a hotspare?