# Global configuration file for MySQL Cluster management

# Gotchas:
# - default sections should be placed before node configuration sections - otherwise they may be ignored
# - some parameters have lower values set for testing purposes and should be changed before switching production traffic to new DB

# ------------------------------------
# NDBD settings for management daemons

[mgm default]

TotalSendBufferMemory=2M

# Site 1

[mgm]
NodeId=1
HostName=inc11-int
PortNumber=1186

# Site 2

[mgm]
NodeId=2
HostName=inc21-int
PortNumber=1186

# ----------------------------
# NDBD settings for data nodes

[ndbd default]
NoOfReplicas=2
DataDir=/opt/mysql-cluster/mysqlc/ndbdata

# For the test purposes, only 1/4 of required memory set here (should be 1500M and 500M)
DataMemory=1200M
IndexMemory=400M

MaxNoOfConcurrentTransactions=80K
MaxNoOfConcurrentOperations=500K
MaxNoOfLocalOperations=800K

MaxNoOfConcurrentIndexOperations=160K
MaxNoOfFiredTriggers=160K

LongMessageBuffer=32M

MaxLCPStartDelay=30

# Disabled because lacking privileges to lock pages in memory
#LockPagesInMainMemory=1
# Disabled as potential OS error risk
#ODirect=1

# Wait for nodes indefinately
StartPartialTimeout=0
StartNoNodeGroupTimeout=60000

TransactionInactiveTimeout=2000
TransactionDeadlockDetectionTimeout=3000

ArbitrationTimeout=10000

LogLevelStartup=15
LogLevelShutdown=15
LogLevelStatistic=15
LogLevelCheckpoint=15
LogLevelNodeRestart=15
LogLevelConnection=15
LogLevelError=15
LogLevelCongestion=15
LogLevelInfo=15
MemReportFrequency=60
StartupStatusReportFrequency=60

# Disabled because lacking privileges to lock threads to cpu
#LockExecuteThreadToCPU=1
#LockMaintThreadsToCPU=0
RealtimeScheduler=1
SchedulerExecutionTimer=80
SchedulerSpinTimer=400
BuildIndexThreads=8
TwoPassInitialNodeRestartCopy=1
Numa=1

MaxNoOfExecutionThreads=8

TotalSendBufferMemory=2M

RedoOverCommitLimit=60

# Site 1

[ndbd]
NodeId=11
NodeGroup=0
HostName=inc11-int

[ndbd]
NodeId=12
NodeGroup=1
HostName=inc12-int

# Site 2

[ndbd]
NodeId=21
NodeGroup=0
HostName=inc21-int

[ndbd]
NodeId=22
NodeGroup=1
HostName=inc22-int

# ---------------------------------------------------------------------------------------------
# MySQL deamons configuration - each daemon slot is configured for specific host in the cluster

[mysqld default]
BatchByteSize=64K

TotalSendBufferMemory=2M
DefaultOperationRedoProblemAction=QUEUE

# Site 1

[mysqld]
HostName=inc11-int

[mysqld]
HostName=inc12-int

[mysqld]
HostName=oma1-int

# Site 2

[mysqld]
HostName=inc21-int

[mysqld]
HostName=inc22-int

[mysqld]
HostName=oma2-int

# ------------------------------------------------
# Direct TCP connections for on-site communication

# Site 1

[tcp]
NodeId1=11
NodeId2=12
HostName1=inc11-int
HostName2=inc12-int

# Site 2

[tcp]
NodeId1=21
NodeId2=22
HostName1=inc21-int
HostName2=inc22-int