1

According to the limitations outlined at http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html, there can only be 48 data nodes.

Does that mean, with number of replicas 2, I can actually have only 24 nodes to store data?

If the data memory is, say 4GB, then, does it mean I can only store 24*4=~100GB?

If so, how can I set up a cluster to store TBs of data?

  • Why would your storage be limited to 4Gb? – Philᵀᴹ Jun 23 '16 at 9:10
  • @Phil, that was just taken arbitrarily. – Babu James Jun 23 '16 at 9:33
  • A single node can store many many Terabytes of data - I don't really understand the problem/question? – Philᵀᴹ Jun 23 '16 at 9:35
  • @Phil, but the cluster configuration needs a value for DataMemory and/or IndexMemory which should be within available physical memory. How in that case will one be able to store terrabytes? – Babu James Jun 23 '16 at 10:11
  • Modern x64 boxes can have several Terabytes of memory... – Philᵀᴹ Jun 23 '16 at 10:17
0

Data does not have to be memory-resident in NDB. (That limitation existed long ago.) So, there is much more than 4GB limitation per pair of servers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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