#
# config.ini
#

# This configuration file is fore MySQL Clusters 6.2 and above...

# ----------------------------------------------------------------------

[TCP DEFAULT]

# Default is too small!
SendBufferMemory              = 2M
ReceiveBufferMemory           = 2M


# When this is configured together with section above ndb_mgmd will
# return with erro -1 (255). This is a bug and should be fixed earlier
# or later!
# When you move this section to the bottom it should work.
# You need one TCP section for EACH cluster node pair!
# (for example: 4 nodes = 6 sections)

# [TCP]
#
# NodeId1: 10
# NodeId2: 11
# Hostname1: 10.40.219.161
# Hostname2: 10.40.219.162

# ----------------------------------------------------------------------

[NDB_MGMD DEFAULT]

DataDir                       = /var/lib/mysql/cluster

# ----------------------------------------------------------------------

[NDB_MGMD]

Id                            = 1
HostName                      = localhost


#[NDB_MGMD]
#
# Id                            = 2
# HostName                      = localhost

# ----------------------------------------------------------------------

[NDBD DEFAULT]

# needs root privileges?
LockPagesInMainMemory         =    1
MemReportFrequency            =  600

# Everything else is not supported
NoOfReplicas                  =    2

# Should be the same on all data node for eas of maintenance
DataDir                       = /var/lib/mysql/cluster
# needs root privileges?
ODirect                       =    1

# Memory sizing either from ndb_size.pl, calculation or ALL DUMP 1000
DataMemory                    =  128M
# IndexMemory = DataMemory / (5 - 10)
IndexMemory                   =   16M

# REDO log sizing
# 256M is the new recommendation
FragmentLogFileSize           =  256M
# 6 x DataMemory / (4 x FragmentLogFileSize)
# >= 6.4
# 6 x DataMemory x NO_OF_LQH_THREADS / (4 * FragmentLogFileSize)
NoOfFragmentLogFiles          =    3

# should be around 16 - 64 MB default is too small (128 MB in extreme cases)
RedoBuffer                    =   32M

# No calculation available
SharedGlobalMemory            =   64M

# 1 second data loss in max.
TimeBetweenGlobalCheckpoints  = 1000

# leave as default to start with
# this is too big under low load (better 6-10)
TimeBetweenLocalCheckpoints   =   20

# On a good I/O system you can set this value higher
Diskcheckpointspeed           =   10M

# Backup and LCP related parameters

# This means full speed
Diskcheckpointspeedinrestart  =  100M

BackupMaxWriteSize            =    1M
BackupLogBufferSize           =    4M
BackupDataBufferSize          =   16M
BackupMemory                  =   20M

# # of expected concurrent trx / # data nodes
# This memory is pre-allocated, thus keep it low!
# leave as default to start with
MaxNoOfConcurrentTransactions =  256

# This memory is pre-allocated, thus keep it low! The default is much too high!
# Every INS/UPD/DEL (= op) uses 1k!!!
# Should be bigger than op/s (10'000 - 100'000) / # data nodes
# MaxNoOfConcurrentTransactions x op/trx x 4
# leave as default to start with. User LIMIT <n> to limit # of op records
# If you want to be on the safe side set it to 100k - 250k
MaxNoOfConcurrentOperations   = 2048

# Defaults of 64 can be fine.
# Each index consumes approx. 15 kbyte per node!
MaxNoOfUniqueHashIndexes      =  160

# Each object consumes approx. 10 kbyte per node!
# Use ndb_size.pl or calculate the number of OI indexes
# Also PK and UK create 1 OI each. Thus this values is at least as big
# as MaxNoOfTables. Usually 2 - 4 times bigger.
# The default of 128 can be too small soon.
MaxNoOfOrderedIndexes         =  256

# Not that each OI, UI and BLOB counts towards one table object
# Usually safe
# Each table consumes approx. 20 kbyte per node!
MaxNoOfTables                 =  128

# Each attribute consumes around 200 bytes of storage per node
# a) 6 x MaxNoOfTables
# b) NoOfTables x AvgAttributsPerTable
MaxNoOfAttributes             = 1024

# Default of 768 is often fine.
# Minmal value = #NoOfTables + #OI + 3 x #UI
MaxNoOfTriggers               =  768

# Default too big.
MaxNoOfLocalScans             =   64

# TimeBetweenEpochs             =  100

# CGE >= 6.3.7
# CompressedLCP                 =    1
# CompressedBackup              =    1

# GCE >= 6.3.4
# RealTimeScheduler             =    1
# SchedulerSpinTimer            =  400
# SchedulerExecutionTimer       =  100

# ----------------------------------------------------------------------

[NDBD]
Id                            =   10
HostName                      = localhost
# CGE >= 6.3.7
# LockExecuteThreadToCPU        = 1
# LockMaintThreadsToCPU         = 0 # on same CPU as eth interupts occur


[NDBD]
Id                            =   11
HostName                      = localhost
# CGE >= 6.3.7
# LockExecuteThreadToCPU        = 1
# LockMaintThreadsToCPU         = 0 # on same CPU as eth interupts occur

# ----------------------------------------------------------------------

[MYSQLD DEFAULT]


[MYSQLD]

Id                            =   20
HostName                      = localhost


# Keep some spare for later
# Prevents cluster restart
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]