Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Ok so i have mysql cluster setup but what i need is say table assets to be split among the nodes, not replicated. as the purpose of me setting up the cluster was due to lack of hard drive space so how do i get the cluster to split the table among the nodes?

I have looked at partitioning but did not find any good martial on it. If anyone knows how to go about partitioning the table Could you please help me.

I know about dbshards ect ect so please do not mention them i need a solution using just mysql and no i cant modify the software that will be using the db

share|improve this question

closed as not a real question by Shane Madden, TheCleaner, ceejayoz, EEAA, Andrew May 7 '13 at 3:24

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

I think you may be in way over your head here. – ceejayoz May 7 '13 at 3:18

not possible using standard mysql. you could look at nbd clustering, but it's a completely separate product made by mysql and not completely compatible.

what type of clustering are you using? replication? that's not clustering.

if the only problem you were running in to is disk space then you don't need more mysql servers, just more storage. a possible solution would be to present a bunch of iscsi storage to your one mysql server and divide it in to a few smaller equally sized volumes. then you could use the partitioning features of mysql abd create hash partitions of your larger tables to evenly distribute them over your volumes.

share|improve this answer

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