jaymc Posted September 22, 2008 Share Posted September 22, 2008 I have an array of 8 10k 36GB disks My databases accumulate 3gb storage What would be the best raid config be I think RAID 1 mirrored for real time backup and twice as fast read access Anyone disagree? Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/ Share on other sites More sharing options...
Mchl Posted September 22, 2008 Share Posted September 22, 2008 I've always been fan of RAID5, but I think with 8 disks RAID 1+0 or 0+1 (never really understood differences between the two) would work good. Anyways, that's probab;ly what you mean, because RAID1 on 8 36GB disks mean you only have 36GB available Edit: RAID 1+0 or 0+1 (never really understood differences between the two) Actually, once I started to compare them with 8 disks instead of 4, the differences became obvious Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-647626 Share on other sites More sharing options...
jaymc Posted September 22, 2008 Author Share Posted September 22, 2008 I was only going to mirror one disk with RAID 1 I'm more concerned that with RAID 0 one disk failure will destroy all data Would RAID 5 work better for mysql? Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-647698 Share on other sites More sharing options...
Mchl Posted September 22, 2008 Share Posted September 22, 2008 RAID5 gets the best of both worlds. It strips your data for faster access and duplicates it for security. All that at a loss of 1 disk worth of diskspace. Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-647704 Share on other sites More sharing options...
jaymc Posted September 22, 2008 Author Share Posted September 22, 2008 That's the answer I was looking for So basically in all situations if you can afford it go with RAID 5 Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-647728 Share on other sites More sharing options...
Mchl Posted September 22, 2008 Share Posted September 22, 2008 Nope. RAID5 is when you have 3, 4, maybe 5 disks. With more disks it's getting more and more prone do failures (as it can survive crash of one disk only). The more disks you have, the more redundancy is needed. Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-647731 Share on other sites More sharing options...
jcombs_31 Posted September 22, 2008 Share Posted September 22, 2008 I'm not sure why you'd want to use 8 disks anyway. Use 5 disks and a RAID 5 setup. Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-648118 Share on other sites More sharing options...
jaymc Posted September 22, 2008 Author Share Posted September 22, 2008 I am not using 8 disks, just thats what I have available Why 5 disks for RAID 5? Why not just 3? Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-648131 Share on other sites More sharing options...
jcombs_31 Posted September 22, 2008 Share Posted September 22, 2008 Because you have so many available. Sure, you can use 3, but I belive with 5 you could have 2 disks fail and still be in good shape until you can swap the drives. Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-648241 Share on other sites More sharing options...
Mchl Posted September 23, 2008 Share Posted September 23, 2008 No. RAID 5 allow for one disk to fail, no matter how many disks in array are there. Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-648467 Share on other sites More sharing options...
jcombs_31 Posted September 23, 2008 Share Posted September 23, 2008 Sorry, looks like it is raid6 that allows 2 drives to fail. Quote Link to comment https://forums.phpfreaks.com/topic/125285-solved-raid-for-mysql/#findComment-649018 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.