up vote 0 down vote favorite
share [g+] share [fb]

I am talking about a computer cluster in which there are total 4 nodes and 8 hard drives of 600GB capacity but if database size goes above 1TB then how mysql database would be divided (stored) over multiple disks?

link|improve this question
If you are looking at that much data; you should consider looking into sharding. Although, sharding can be quite problematic it is a solution that might help you with expanding data sizes. – Suroot Jul 18 '11 at 21:44
Please pardon me, I should have posted this question at serverfaults. :( – Gary Lindahl Jul 18 '11 at 22:52
2  
8 drives but in what configuration? If it's RAID (and if not,why not?) then that's effectively a single drive, not 8 drives. – John Gardeniers Jul 19 '11 at 5:07
2  
Having seen your three questions so far on SF can I strongly suggest that you hire a designer for this work, I don't mean this in a rude way but you're clearly out of your depth and almost certain to make large and hard-to-fix design issues. – Chopper3 Jul 19 '11 at 16:52
^^Not rude at all and indeed its a good idea. Would you recommend couple of good designers? – Gary Lindahl Jul 20 '11 at 18:49
feedback

migrated from stackoverflow.com Jul 19 '11 at 4:23

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 0 down vote

You can grow beyond the capacity of a single disk using a RAID setup. From your description it is not clear whether you are already using RAID. You claim to already have more than 1 hard drive per server - are they only configured as a mirror (RAID-1)?

link|improve this answer
Sorry for the confusion actually I am likely to face this situation and currently its not on ground situation. So, please tell me how when RAID will be implemented how login node will know about the particular database record is saved on which disk? – Gary Lindahl Jul 18 '11 at 22:54
You don't know how RAID works? I think you've got a lot of reading to do. – womble Jul 19 '11 at 17:43
feedback
up vote 0 down vote

Read up on MySql Partitioning

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.