Re: Mysql NDB Cluster error while restoration of data "ERROR 1114 (HY000) at line 25: The table 'table1' is full"

[Mauritz Sundell]

Hi Purval

Ndb is by default an in-memory database, only writing to disk to have a disk durable state.

If your sql files is 2.2GB most likely you will need that or even a bit more as DataMemory. Please increase DataMemory.

To increase the capacity of a Ndb cluster further one can either add more nodegroups or make part of data stored on disk.

Currently you have one nodegroup with two data nodes, both will store all your data to not loose any data if one node goes down.

Some information about nodegroups can be found in:
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node.html

For information about store some data on disk see:
https://dev.mysql.com/doc/mysql-cluster-excerpt/8.0/en/mysql-cluster-disk-data.html

Note that indexes are always in memory, and columns needed for index can not be stored on disk.

Regards,
Mauritz