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
259
March 10, 2023 04:53AM


Sorry, you can't reply to this topic. It has been closed.

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.