#
# This config.ini file was generated by ndbinstaller.
#

[NDBD DEFAULT]
#The number of copies of the data stored on different nodes in the cluster
NoOfReplicas=2

#The amount of main memory (RAM) used to store columns and ordered indexes in tables, plus some overhead
DataMemory=1024M

#The amount of main memory (RAM) used to hash indexes in tables, plus some overhead
IndexMemory=205M

#If you have lots of tables (>1000), then you may get 'Error 773' and need to increase this (25 would be reasonable)
StringMemory=25

#The amount of disk space (NoOfFragmentLogFiles * 64MB) used to store the Redo Log (used for node recovery)
NoOfFragmentLogFiles=7

#The speed at which LocalCheckpoints (LCP) are written to disk
DiskCheckpointSpeed=100M

#The speed at which LocalCheckpoints (LCP) are written to disk, as part of a node recovery 
DiskCheckpointSpeedInRestart=100M

#The size of the RedoLog Buffer in memory; Reduce for improved disk throughput (but slower recovery time)
DiskSyncSize=4M

#The size of the RedoBuffer used to buffer writes to the disk subsystem. Increase for high write-rate or slow disk.
RedoBuffer=8M

#The maximum time in ms that is permitted to lapse between operations in the same transaction before the transaction is aborted.
TransactionInactiveTimeout=2000

#Time in ms between global checkpoint groups are flushed from memory to disk
TimeBetweenGlobalCheckpoints=1000

#Time in ms between local checkpoints of memory to local disk. Increase this if system is highly loaded to improve node restart times.
TimeBetweenLocalCheckpoints=20

#Represents the number of seconds between memory usage reports written to the cluster log
MemReportFrequency=300

#This prevents ndbd processes and DB memory from being swapped out to disk
LockPagesInMainMemory=1

#
# TRANSACTION PARAMETERS
#

#The number of transaction records available at each data node. Increase this if you have a higher number of concurrent transactions
MaxNoOfConcurrentTransactions=4096

#The number of operation records available at each data node. Increase this if you have a higher number of concurrent operations
MaxNoOfConcurrentOperations=32768

#The number of operation records available at each data node for queries that use a hash index. Increase this if you have a higher number of concurrent operations
MaxNoOfConcurrentIndexOperations=8192


#
# Scans and Buffering
#

# Max number of parallel scans. Max value is 500.
MaxNoOfConcurrentScans=256

#Note: 'alter table' requires 3 times the number of attributes that are in the original table. 
MaxNoOfAttributes=1000

#A table is required not just for a table, but also for every unique hash index and every ordered index. Maximum value is 1600, minimum is 8.
MaxNoOfTables=128

#Each ordered index requires 10KB of memory.
MaxNoOfOrderedIndexes=128

#Each unique hash index requires 15KB of memory.
MaxNoOfUniqueHashIndexes=64

#Replication, unique index operations, backups and order index operations require trigger objects.
MaxNoOfTriggers=768

# 
#Backup Parameters
#The following must hold when updating backup params:
# 1. BackupDataBufferSize >= BackupWriteSize + 188KB
# 2. BackupLogBufferSize >= BackupWriteSize + 16KB
# 3. BackupMaxWriteSize >= BackupWriteSize
#

#Increase if slow disk subsystem when making a backup. 
BackupDataBufferSize=2M

#Increase if slow disk subsystem when making a backup. 
BackupLogBufferSize=2M

#Default size of msgs written to disk. This value must be less than or equal to BackupMaxWriteSize.
BackupWriteSize=32000

#Max size of msgs written to disk. This value must be greater than or equal to than BackupMaxWriteSize.
BackupMaxWriteSize=256000



#
# Real-time params
#

#Setting this to '1' enables real-time scheduling of ndb threads.
#RealtimeScheduler=0

#Time in microseconds for threads to be executed in the scheduler before being sent.
#SchedulerExecutionTimer=50

#Time in microseconds for threads to be executed in the scheduler before sleeping.
#SchedulerSpinTimer=0

#Whether a ndbd process should halt or be restarted if there is an error in it.
StopOnError=true

#where disk-based user data will be used for the cluster
Diskless=false

#Data nodes attempt to use O_DIRECT when writing LCPs, backups and redo logs.
#Should be disabled for 2.4 or older kernels, enabled for 2.6 or higher kernels
ODirect=true


[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]
# I found  this settting buggy with 5.1.17-beta, when starting ndb_mgmd process.
# SendBufferMemory=2M

# Management Server
[NDB_MGMD]
HostName=evgsics11
PortNumber=1186
DataDir=/home/jim/.mysql/logs
LogDestination=FILE:filename=/home/jim/.mysql/logs/cluster.log,maxsize=1000000,maxfiles=6
NodeID=63


[NDBD]
HostName=evgsics12
DataDir=/home/jim/.mysql/logs
FileSystemPath=/home/jim/.mysql/ndb/ndb_data/1
NodeID=1
#Assign this data node to a CPU-ID
#LockExecuteThreadToCPU=
#LockMaintThreadToCPU=

[NDBD]
HostName=evgsics14
DataDir=/home/jim/.mysql/logs
FileSystemPath=/home/jim/.mysql/ndb/ndb_data/2
NodeID=2
#Assign this data node to a CPU-ID
#LockExecuteThreadToCPU=
#LockMaintThreadToCPU=


# Setup node IDs for mySQL API-servers (clients of the cluster)
[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]