MySQL NDB cluster maximum data size

Question

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?

A single node can store many many Terabytes of data - I don't really understand the problem/question? — Philᵀᴹ, Commented Jun 23, 2016 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, Commented Jun 23, 2016 at 10:11

Rick James · Accepted Answer · 2016-07-03 05:21:54Z

1

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.

answered Jul 3, 2016 at 5:21

Rick James

79.4k5 gold badges51 silver badges117 bronze badges

Add a comment |

1 Answer 1