#
# Define cluster with two MySQL Servers and two data nodes,
# primarily intended to be used for testing MySQL Server + ndbcluster plugin
#
[cluster_config.crunch]
ndbd=,
ndb_mgmd=
mysqld=,
ndbapi=,,,

# Configure data nodes
[cluster_config]
NoOfReplicas=2
DataMemory=4G
# For large machine
#DataMemory=128G

# Auto configure NDB to use all CPUs assigned
AutomaticThreadConfig=1

# Set number of parallel REDO logs per node to the number of LDM threads
# (this assumes that the auto config assigns 8 LDM threads).
NoOfFragmentLogParts=8

# Prevent disk-swapping
LockPagesInMainMemory=1

# Enable shared memory Transporter (improves performance)
UseShm=1

# Allocates sufficient REDO log to cope with load step
RedoBuffer=256M
FragmentLogFileSize=1G
NoOfFragmentLogFiles=4
# For large machine
#NoOfFragmentLogFiles=256

SendBufferMemory=8M
# For higher load
#SendBufferMemory=256M

# Configure MySQL Server(s)
[mysqld]
# Use ndbcluster plugin
ndbcluster
# Turn on highest log level
ndb-extra-logging=99

# Turn off X plugin to allow config to
# use those ports as well
loose-mysqlx=0

# Allow large number of connected clients
max-connections=8200

# Turn off general and slow query log
general_log=OFF
slow_query_log=OFF

# Allow many prepared statements
max_prepared_stmt_count=4194304

# Setup first MySQL Server as binlogging
[mysqld.1.crunch]
ndb-log-bin=1
#binlog-checksum=none
#binlog-transaction-compression=ON

[ENV]
# Always use ndbmtd for the data nodes
MTR_NDBMTD=1

# Setup connectstring for the cluster
NDB_CONNECTSTRING=@mysql_cluster.crunch.ndb_connectstring