#
# config.ini
#

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

[TCP DEFAULT]


#[TCP]
SendBufferMemory            = 2M

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

[NDB_MGMD DEFAULT]

DataDir                     = /var/lib/mysql/cluster

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

[NDB_MGMD]

Id                          = 1
HostName                    = localhost

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

[NDBD DEFAULT]

LockPagesInMainMemory       = 1

# Everything else is not supported
NoOfReplicas                = 2

# Should be the same on all data node for eas of maintenance
DataDir                     = /var/lib/mysql/cluster/mysql-cluster

# Memory sizing either from ndb_size.pl, calculation or ALL DUMP 1000
DataMemory                  = 512M
IndexMemory                 =  256M

# REDO and UNDO sizing
# 5.0
# 6 x (DataMemory + IndexMemory) / 64 MB
# 5.1
# 6 x DataMemory / 64 MB
NoOfFragmentLogFiles        = 72
# should be around 16 - 64 MB default is too small
RedoBuffer                  = 32M

# UndoBuffer = (1-2) x RedoBuffer
# Same ratio as DataMemory / IndexMemory
# 5.0 only
UndoDataBuffer              = 64M
UndoIndexBuffer             = 32M

# No calculation available
# 5.1 only
#SharedGlobalMemory           = 128M

# leave as default to start with
TimeBetweenGlobalCheckpoints = 2000
TimeBetweenLocalCheckpoints  = 20

# # 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!
# 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
MaxNoOfConcurrentOperations = 2048

# Defaults are fine
# Each index consumes approx. 15 kbyte per node!  --> has to be tested!
MaxNoOfUniqueHashIndexes    = 16384

# Each object consumes approx. 10 kbyte per node! --> has to be tested!!!
# Which dump?
# Use ndb_size.pl or calculate the number of OI indexes 
#MaxNoOfOrderedIndexes       = 512 - 16384

# Not that each OI, UI and BLOB counts towards one table object
# Usually safe
MaxNoOfTables = 512

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

[NDBD]
Id                          = 10
HostName                    = localhost


[NDBD]
Id                          = 11
HostName                    = localhost

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

[MYSQLD DEFAULT]


[MYSQLD]

Id                          = 20
HostName                    = localhost


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