mysql cluster 配置参数

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