[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2      # Number of replicas
# Available memory = 12000M
DataMemory=10254M    # How much memory to allocate for data storage
IndexMemory=1282M   # How much memory to allocate for index storage
                    # This leaves about 2048M for the server.

LockPagesInMainMemory=1
TransactionBufferMemory=8M
DataDir=/usr/local/mysql/data   # Directory for each data node's data files

NoOfFragmentLogFiles=960
ServerPort=2202   

# The values provided for DataMemory and IndexMemory assume 4 GB RAM
#DataMemory=3072M
#IndexMemory=384M


# Enabling this parameter causes NDBCLUSTER to try using O_DIRECT
# writes for local checkpoints and redo logs; this can reduce load on
# CPUs. We recommend doing so when using MySQL Cluster on systems running
# Linux kernel 2.6 or later.
# ODirect=1

MaxNoOfConcurrentOperations=1000000
MaxNoOfLocalOperations=1100000

#SchedulerSpinTimer=400
#SchedulerExecutionTimer=100
#RealTimeScheduler=1
# Setting these parameters allows you to take advantage of real-time scheduling
# of NDBCLUSTER threads to get higher throughput.

#TimeBetweenGlobalCheckpoints=1000
#TimeBetweenEpochs=200
#DiskCheckpointSpeed=10M
#DiskCheckpointSpeedInRestart=100M
RedoBuffer=32M

# CompressedLCP=1
# CompressedBackup=1
# Enabling CompressedLCP and CompressedBackup causes, respectively, local
#checkpoint files and backup files to be compressed, which can result in a space
#savings of up to 50% over noncompressed LCPs and backups.

#MaxNoOfLocalScans=64
MaxNoOfTables=2048
MaxNoOfOrderedIndexes=2048
MaxNoOfAttributes=24576

[tcp default]
# TCP/IP options:
SendBufferMemory=16M
ReceiveBufferMemory=4M
portnumber=2202   # This the default
                  # From experience it is important to set this parameter.
TcpBind_INADDR_ANY=1


 
[ndb_mgmd]
# Management process options:
hostname=192.168.149.239            # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster      # Directory for MGM node log files
LogDestination=FILE:filename=/var/lib/mysql-cluster/ndb_50_cluster.log,maxsize=1000000,maxfiles=6
NodeId=50

 
[ndb_mgmd]
# Management process options:
hostname=192.168.149.238            # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster      # Directory for MGM node log files
LogDestination=FILE:filename=/var/lib/mysql-cluster/ndb_51_cluster.log,maxsize=1000000,maxfiles=6
NodeId=51


[ndbd]
# Options for data node:
hostname=192.168.149.237            # Hostname or IP address
datadir=/usr/local/mysql/data       # Directory for this data node's data files
NodeId=1

[ndbd]
# Options for data node:
hostname=192.168.149.236            # Hostname or IP address
datadir=/usr/local/mysql/data       # Directory for this data node's data files
NodeId=2


[mysqld]
# SQL node options:
hostname=192.168.149.239            # Hostname or IP address
NodeId=100
[mysqld]
# SQL node options:
hostname=192.168.149.238            # Hostname or IP address
NodeId=101

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[mysqld]
# SQL node spare socket:

[tcp]
# Direct TCP connections between data nodes
NodeId1=1
NodeId2=2
HostName1=192.168.160.11
HostName2=192.168.160.12