Re: NDB data node failed and sent another data node into a crash loop

[Richard Cruise]

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