MySQL Forums
Forum List  »  NDB clusters

Re: need to add new ndb data node to my cluster
Posted by: Mauritz Sundell
Date: March 10, 2023 04:53AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: need to add new ndb data node to my cluster
126
March 10, 2023 04:53AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.