MySQL Forums
Forum List  »  NDB clusters

Settings optimization for NDB cluster
Posted by: Alexandre Westfahl
Date: October 25, 2019 08:08PM

Hello,

I have a cluster running with the following configuration:
[NDB_MGMD DEFAULT]
Portnumber=1186

[NDB_MGMD]
NodeId=21
HostName=172.XX.11.21
DataDir=/home/cluster/
Portnumber=1186

[TCP DEFAULT]
SendBufferMemory=4M
ReceiveBufferMemory=4M

[NDBD DEFAULT]
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=80G
#IndexMemory=20G
MaxNoOfTables=4096
MaxNoOfTriggers=3500
NoOfReplicas=2
StringMemory=25
DiskPageBufferMemory=64M
SharedGlobalMemory=500M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=16384
MaxNoOfConcurrentOperations=64000
BatchSizePerLocalScan=512
FragmentLogFileSize=256M
NoOfFragmentLogFiles=455
RedoBuffer=32M
MaxNoOfExecutionThreads=12
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=1500
HeartbeatIntervalDbApi=1500
MaxNoOfAttributes=5000
StartPartialTimeout=60
StartPartitionedTimeout=60
MaxNoOfOrderedIndexes=5000
MaxNoOfUniqueHashIndexes=128
TransactionDeadlockDetectionTimeout=2000

[NDBD]
NodeId=11
HostName=172.XX.11.11
DataDir=/home/cluster/
ServerPort=50501

[NDBD]
NodeId=12
HostName=172.XX.11.12
DataDir=/home/cluster/
ServerPort=50502

[MYSQLD DEFAULT]

[MYSQLD]
NodeId=31
HostName=172.XX.11.31
[MYSQLD]
NodeId=32
HostName=172.XX.11.32
[MYSQLD]
NodeId=33
HostName=172.XX.11.33
[MYSQLD]
NodeId=34
HostName=172.XX.11.34

# TCP/IP Connections
[tcp]
NodeId1=11
NodeId2=12
HostName1=10.10.10.1
HostName2=10.10.10.2


The data node servers have the following specs:
E5-2650 0 @ 2.00GHz x2
56GB x2 (Total of 112GB)
Raid 0+1 disks

I wish to improve performance by adding more mysql nodes and 2 data nodes.

Please tell me if you think some of the parameters are wrongly set.

Best Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Settings optimization for NDB cluster
261
October 25, 2019 08:08PM


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.