Re: need to add new ndb data node to my cluster

[Mauritz Sundell]

Hi Tony

Changing the number of replicas (NoOfReplicas) requires an initial system restart:
- turn off application load on database
- take backup
- shutdown all nodes
- change configuration: change NoOfReplicas and add a data node
- start data nodes with initial (ndbd/ndbmtd --initial) which will remove all data from cluster
- restore data from backup
- turn on application load again

Also if you need to use three or four replicas it is recommended to use MySQL Cluster 8.0.

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-noofreplicas

Regards,
Mauritz