MySQL Forums
Forum List  »  NDB clusters

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

Options: ReplyQuote


Subject
Views
Written By
Posted
ndb7.5.7's ndbmtd cann't start as ndbd
933
September 15, 2018 12:52AM
442
September 18, 2018 06:23AM


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.