Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

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

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

1  
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
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

2 Answers 2

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)?

share|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

Read up on MySql Partitioning

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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