MySQL Forums
Forum List  »  NDB clusters

Re: NDB data node failed and sent another data node into a crash loop
Posted by: Richard Cruise
Date: January 27, 2022 04:32AM

Here is our config file for references

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=3 # Number of replicas
DataMemory=8192M
MaxNoOfOrderedIndexes=1028 # default 128
MaxNoOfAttributes=500000 # default 4000
MaxNoOfTables=1028 # default 128
AutomaticThreadConfig=true # default false
MaxNoOfConcurrentTransactions=12288 # default 4096

[ndb_mgmd]
# Management process options:
HostName=node01 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=1

[ndb_mgmd]
# Management process options:
HostName=node02 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=2

[ndb_mgmd]
# Management process options:
HostName=node03 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=3


[ndbd]
# Options for data node "A":
# # (one [ndbd] section per data node)
HostName=node01 # Hostname or IP address
NodeId=17 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files
ServerPort=11001

[ndbd]
# Options for data node "B":
HostName=node02 # Hostname or IP address
NodeId=18 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files
ServerPort=11002

[ndbd]
# Options for data node "C":
HostName=node03 # Hostname or IP address
NodeId=19 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files
ServerPort=11003

[mysqld]
# SQL node options:
HostName=node01 # Hostname or IP address
NodeId=33 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node01 # Hostname or IP address
NodeId=34 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node01 # Hostname or IP address
NodeId=35 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node01 # Hostname or IP address
NodeId=36 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node01 # Hostname or IP address
NodeId=37 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node01 # Hostname or IP address
NodeId=38 # Node ID for this api node

[mysqld]
# SQL node options:
HostName=node02 # Hostname or IP address
NodeId=39 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node02 # Hostname or IP address
NodeId=40 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node02 # Hostname or IP address
NodeId=41 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node02 # Hostname or IP address
NodeId=42 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node02 # Hostname or IP address
NodeId=43 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node02 # Hostname or IP address
NodeId=44 # Node ID for this api node

[mysqld]
# SQL node options:
HostName=node03 # Hostname or IP address
NodeId=45 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node03 # Hostname or IP address
NodeId=46 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node03 # Hostname or IP address
NodeId=47 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node03 # Hostname or IP address
NodeId=48 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node03 # Hostname or IP address
NodeId=49 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=node03 # Hostname or IP address
NodeId=50 # Node ID for this api node

[ndbd]
# Options for data node "C":
HostName=pcamn03 # Hostname or IP address
NodeId=19 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files
ServerPort=11003

[mysqld]
# SQL node options:
HostName=pcamn01 # Hostname or IP address
NodeId=33 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn01 # Hostname or IP address
NodeId=34 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn01 # Hostname or IP address
NodeId=35 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn01 # Hostname or IP address
NodeId=36 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn01 # Hostname or IP address
NodeId=37 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn01 # Hostname or IP address
NodeId=38 # Node ID for this api node

[mysqld]
# SQL node options:
HostName=pcamn02 # Hostname or IP address
NodeId=39 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn02 # Hostname or IP address
NodeId=40 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn02 # Hostname or IP address
NodeId=41 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn02 # Hostname or IP address
NodeId=42 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn02 # Hostname or IP address
NodeId=43 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn02 # Hostname or IP address
NodeId=44 # Node ID for this api node

[mysqld]
# SQL node options:
HostName=pcamn03 # Hostname or IP address
NodeId=45 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn03 # Hostname or IP address
NodeId=46 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn03 # Hostname or IP address
NodeId=47 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn03 # Hostname or IP address
NodeId=48 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn03 # Hostname or IP address
NodeId=49 # Node ID for this api node
[mysqld]
# SQL node options:
HostName=pcamn03 # Hostname or IP address
NodeId=50 # Node ID for this api node

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: NDB data node failed and sent another data node into a crash loop
110
January 27, 2022 04:32AM


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.