###
# NDB Config for NDB 7.0.5
###

[TCP DEFAULT]
SendBufferMemory = 16M

[NDBD DEFAULT]
NoOfReplicas = 2
MaxNoOfConcurrentTransactions = 8192
MaxNoOfConcurrentOperations = 1500000
MaxNoOfOrderedIndexes = 8192
MaxNoOfTables = 4048
MaxNoOfAttributes = 14336
MaxNoOfTriggers = 7168
TimeBetweenLocalCheckpoints = 10

NoOfFragmentLogFiles = 40
FragmentLogFileSize = 128M
InitFragmentLogFiles = FULL

RedoBuffer = 1G
#LockPagesInMainMemory = 1
DiskCheckpointSpeed = 50M
#DiskPageBufferMemory = 5G
SharedGlobalMemory = 1G
DiskSyncSize = 32M
#LockExecuteThreadToCPU = 1
#LockMaintThreadsToCPU = 4
DiskIOThreadPool = 24
MaxNoOfExecutionThreads = 8


# Management process options:
[NDB_MGMD]
hostname = 192.168.0.4 # Admin
datadir = /var/log/mysql/cluster

[NDBD]
ID = 2
hostname = 192.168.0.40           # DBDATA-1-1
DataDir = /db/datadir 
BackupDataDir = /db/backups
DataMemory = 16G  
IndexMemory = 7G
MaxNoOfConcurrentOperations = 1500000
TransactionDeadlockDetectionTimeout = 3000

[NDBD]
ID = 3
hostname = 192.168.0.41           # DBDATA-1-2
DataDir = /db/datadir
BackupDataDir = /db/backups
DataMemory = 16G 
IndexMemory = 7G
MaxNoOfConcurrentOperations = 1500000
TransactionDeadlockDetectionTimeout = 3000

[NDBD]
ID = 4
hostname = 192.168.0.42          # DBDATA-2-1
DataDir = /db/datadir   
BackupDataDir = /db/backups
DataMemory = 16G
IndexMemory = 7G
MaxNoOfConcurrentOperations = 1500000
TransactionDeadlockDetectionTimeout = 3000

[NDBD]
ID = 5
hostname = 192.168.0.43           # DBDATA-2-2
DataDir = /db/datadir
BackupDataDir = /db/backups
DataMemory = 16G
IndexMemory = 7G
MaxNoOfConcurrentOperations = 1500000
TransactionDeadlockDetectionTimeout = 3000

# SQL node options:
[MYSQLD]
ID = 6
hostname = 192.168.0.11           # DB_Host1

[MYSQLD]
ID = 7
hostname = 192.168.0.12           # DB_Host2

[MYSQLD]
ID = 8
hostname = 192.168.0.9           # NFS1

[MYSQLD]
ID = 9
hostname = 192.168.0.10           # NFS2

[MYSQLD]
ID = 10
hostname = 192.168.0.20           # Node1

[MYSQLD]
ID = 11
hostname = 192.168.0.21           # Node2

[MYSQLD]
ID = 12
hostname = 192.168.0.22           # Node3

[MYSQLD]
ID = 13
hostname = 192.168.0.23           # Node4

[MYSQLD]
ID = 14
hostname = 192.168.0.24           # Node5

[MYSQLD]
ID = 15
hostname = 192.168.0.25           # Node6

[MYSQLD]
ID = 16
hostname = 192.168.0.26           # Node7

[MYSQLD]
ID = 17
hostname = 192.168.0.27           # Node8

[MYSQLD]
ID = 18
hostname = 192.168.0.28           # Node9

[MYSQLD]
ID = 19
hostname = 192.168.0.29           # ICG-Dev

[MYSQLD]
ID = 20
hostname = 192.168.0.30           # Vendor-Node1

[MYSQLD]
ID = 21
hostname = 192.168.0.31           # Vendor-Node2

[MYSQLD]
ID = 22
hostname = 192.168.0.32           # Vendor-Node3

[MYSQLD]
ID = 23
hostname = 192.168.0.33           # Vendor-Node4

[MYSQLD]
ID = 24
hostname = 192.168.0.34           # Vendor-Node5

[MYSQLD]
ID = 25
hostname = 192.168.0.17           # Mailhost1


[MYSQLD]
ID = 26
hostname = 192.168.0.4           # Admin


# Reserved for future API Nodes
[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

## DBHost-1-1 <-> DBHost-1-2
[TCP]
NodeId1 = 2
NodeId2 = 3
HostName1 = 10.99.0.2
HostName2 = 10.99.0.3

## DBHost-1-1 <-> DBHost-2-1
[TCP]
NodeId1 = 2
NodeId2 = 4
HostName1 = 10.99.0.2
HostName2 = 10.99.0.4

## DBHost-1-1 <-> DBHost-2-2
[TCP]
NodeId1 = 2
NodeId2 = 5
HostName1 = 10.99.0.2
HostName2 = 10.99.0.5

## DBHost-1-2 <-> DBHost-2-1
[TCP]
NodeId1 = 3
NodeId2 = 4
HostName1 = 10.99.0.3
HostName2 = 10.99.0.4

## DBHost-1-2 <-> DBHost-2-2
[TCP]
NodeId1 = 3
NodeId2 = 5
HostName1 = 10.99.0.3
HostName2 = 10.99.0.5

## DBHost-2-1 <-> DBHost-2-2
[TCP]
NodeId1 = 4
NodeId2 = 5
HostName1 = 10.99.0.4
HostName2 = 10.99.0.5