ndb_mgmd
[ndb_mgmd default]
datadir = /usr/local/mysql/data
[ndbd default]
NoOfReplicas = 2
DataMemory = 80M
IndexMemory = 18M
datadir = /usr/local/mysqlcluster/data
StringMemory = 50
MaxNoOfTables = 4096
MaxNoOfOrderedIndexes = 2048
MaxNoOfUniqueHashIndexes = 1024
MaxNoOfAttributes = 24576
MaxNoOfTriggers = 10240
MaxNoOfConcurrentTransactions = 409600
MaxNoOfConcurrentOperations = 3276800
###MaxNoOfLocalOperations = 55000
TimeBetweenGlobalCheckpoints = 1000
TimeBetweenEpochs = 100
TimeBetweenWatchdogCheckInitial = 60000
TransactionBufferMemory = 20M
DiskCheckpointSpeed = 20M
DiskCheckpointSpeedInRestart = 100M
TimeBetweenLocalCheckpoints = 20
SchedulerSpinTimer = 400
SchedulerExecutionTimer = 100
RealTimeScheduler = 1
BackupMaxWriteSize = 2M
BackupDataBufferSize = 32M
BackupLogBufferSize = 8M
BackupMemory = 40M
MaxNoOfExecutionThreads = 4
TransactionDeadLockDetectionTimeOut = 15000
BatchSizePerLocalScan = 512
###Increasing the LongMessageBufferb/c of a bug (20090903)
LongMessageBuffer = 16M
###Heartbeating
HeartbeatIntervalDbDb = 15000
HeartbeatIntervalDbApi = 15000
FragmentLogFileSize = 256M
NoOfFragmentLogFiles = 16
[ndb_mgmd]
NodeId = 1
HostName = 192.168.24.138
[ndbd]
NodeId = 11
HostName = 192.168.24.139
[ndbd]
NodeId = 12
HostName = 192.168.24.140
[mysqld]
NodeId = 81
HostName = 192.168.24.141
[mysqld]
NodeId = 82
HostName = 192.168.24.142
sql my.cnf 配置
[mysqld]
basedir = /usr/local/mysqlcluster
datadir = /usr/local/mysqlcluster/data
default-storage-engine = ndbcluster
slow-query-log = on
slow_query_log_file = /usr/local/mysql/data/slow-query.log
long_query_time = 5
skip-external-locking
key_buffer_size = 600M
max_allowed_packet = 100M
table_open_cache = 2048
sort_buffer_size = 1024M
net_buffer_length = 8K
read_buffer_size = 400M
read_rnd_buffer_size = 200M
lower_case_table_names =1
back_log = 384
thread_stack = 256K
join_buffer_size = 500M
thread_cache_size = 200
query_cache_size = 640M
tmp_table_size = 256M
max_connections = 5000
max_connect_errors = 10000000
wait_timeout = 2880000
interactive_timeout = 2880000
thread_concurrency = 8
ndbcluster
ndb-connectstring = 192.168.24.138
[mysql_cluster]
ndb-connectstring = 192.168.24.138
[mysqld]
basedir = /usr/local/mysqlcluster
datadir = /usr/local/mysqlcluster/data
ndbcluster
ndb-connectstring = 192.168.24.138
[mysql_cluster]
ndb-connectstring = 192.168.24.138
ndb 配置
[mysqld]
ndbcluster
ndb-connectstring = 192.168.24.138
[mysql_cluster]
ndb-connectstring = 192.168.24.138