ndb7.5.7's ndbmtd cann't start as ndbd
Posted by:
George lin
Date: September 15, 2018 12:52AM
Dear pioneers,
I am installing NDB7.5.7 on 3 manchines: 1 master and 1 datanode is 2 cpu with 8 cores each, one datanode is 1 cpu with 8 core,
I can run 2 ndbd but when I run ndbmtd with the same config.ini, I got the errors:
Node 23: Forced node shutdown completed. Occured during startphase 0. Caused by error 6050: 'WatchDog terminate, internal error or massive overload on the machine running this node(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
Node 24: Forced node shutdown completed. Occured during startphase 0. Caused by error 6050: 'WatchDog terminate, internal error or massive overload on the machine running this node(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
is the reason caused by only one of ndb data node is 2 cpus?
and my config.ini is as below:
[NDBD DEFAULT]
#1: 表示只有一份数据,但是分成n块分别存储在n个数据节点上。2:数据被分成n/2块,每
块数据都有2个备份,这样即使有任意一个节点发生故障,只要它的备份节点正常,系统就
可以正常运行
NoOfReplicas=2
#以下参数都可再优化
DataDir=/usr/local/mysqlLinJiaXin/ndbdata
DataMemory=8000M
IndexMemory=1000M
##BackupMemory: 64M
##ljx新增
#ok MaxNoOfExecutionThreads=6
MaxNoOfExecutionThreads=10
DiskPageBufferMemory=160M
BackupDataDir=/usr/local/mysqlLinJiaXin/ndbBack
BackupDataBufferSize=160M
BackupLogBufferSize=32M
BackupMemory=192M
BackupWriteSize=2048K
BackupMaxWriteSize=8M
LockPagesInMainMemory=0
#MHX LockExecuteThreadToCPU=0
#MHX LockMaintThreadsToCPU=1
[root@HadoopMaster mysqlLinJiaXin]# cp YHconfig.iniLogConcur YHconfig.iniLogConcurHD
[root@HadoopMaster mysqlLinJiaXin]# ndb_mgmd -f ./YHconfig.iniLogConcur --reload --initial --ndb-nodeid=22
MySQL Cluster Management Server mysql-5.7.23 ndb-7.5.11
2018-09-15 14:26:05 [MgmtSrvr] WARNING -- at line 16: [DB] BackupMemory is deprecated, use Total memory allocated for backups per node (in bytes) instead
[root@HadoopMaster mysqlLinJiaXin]# more YHconfig.iniLogConcurHD
[NDBD DEFAULT]
NoOfReplicas=2
#以下参数都可再优化
DataDir=/usr/local/mysqlLinJiaXin/ndbdata
DataMemory=8000M
IndexMemory=1000M
##BackupMemory: 64M
##ljx新增
#ok MaxNoOfExecutionThreads=6
MaxNoOfExecutionThreads=10
DiskPageBufferMemory=160M
BackupDataDir=/usr/local/mysqlLinJiaXin/ndbBack
BackupDataBufferSize=160M
BackupLogBufferSize=32M
BackupMemory=192M
BackupWriteSize=2048K
BackupMaxWriteSize=8M
LockPagesInMainMemory=0
#MHX LockExecuteThreadToCPU=0
#MHX LockMaintThreadsToCPU=1
RealtimeScheduler=1
MaxNoOfConcurrentTransactions: 851798
MaxNoOfConcurrentOperations: 8517980
SchedulerExecutionTimer=10
SchedulerSpinTimer=100
#CompressedLCP=1
#CompressedBackup=1
#Enabling CompressedLCP and CompressedBackup causes, respectively, local
## Transaction Parameters #
#MaxNoOfConcurrentTransactions: 4096
#MaxNoOfConcurrentOperations: 100000
MaxNoOfLocalOperations: 110000
MaxNoOfTables = 1024
MaxNoOfAttributes = 100000
MaxNoOfOrderedIndexes = 10000
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
#ljx新增
#SendBufferMemory=2M
#ReceiveBufferMemory=2M
[NDB_MGMD]
Nodeid=22
#管理节点服务器
HostName=192.168.70.12
PortNumber=8518
# Storage Engines
DataDir=/usr/local/mysqlLinJiaXin/mgmdata
[NDBD]
Nodeid=23
#MySQL集群db1的IP地址
HostName=192.168.70.13
[NDBD]
Nodeid=24
#MySQL集群db2的IP地址
HostName=192.168.70.14
[MYSQLD]
Nodeid=25
HostName=192.168.70.13
[MYSQLD]
Nodeid=26
HostName=192.168.70.14
[MYSQLD]
Oracle&MCluster lover: Georgelin,
Share monthly salary with the person who recommend a big-data relative job to me now,
Personal cross platform website: www.gloCalHelp.com(Official) or glocalhelp.servebeer.com(temp),
Mobile: 0086 180 500 42436 or 156 6865 8383