# # Configuration file for sgyt-cluster # [NDB_MGMD DEFAULT] Portnumber=1186 [NDB_MGMD] NodeId=49 HostName=172.20.2.50 DataDir=/home/mysql/cluster/admin/ Portnumber=1186 [NDB_MGMD] NodeId=53 HostName=172.20.2.56 DataDir=/home/mysql/cluster/admin/ Portnumber=1186 [TCP DEFAULT] SendBufferMemory=24M ReceiveBufferMemory=24M [NDBD DEFAULT] BackupMaxWriteSize=1M BackupDataBufferSize=16M BackupLogBufferSize=4M BackupMemory=20M BackupReportFrequency=10 MemReportFrequency=30 LogLevelStartup=15 LogLevelShutdown=15 LogLevelCheckpoint=8 LogLevelNodeRestart=15 DataMemory=7168M IndexMemory=2048M MaxNoOfTables=10000 MaxNoOfTriggers=10000 MaxNoOfFiredTriggers=1000000 NoOfReplicas=2 StringMemory=25 DiskPageBufferMemory=64M SharedGlobalMemory=20M LongMessageBuffer=32M MaxNoOfConcurrentTransactions=16384 BatchSizePerLocalScan=512 FragmentLogFileSize=256M NoOfFragmentLogFiles=57 RedoBuffer=64M MaxNoOfExecutionThreads=2 StopOnError=false LockPagesInMainMemory=0 TimeBetweenEpochsTimeout=32000 TimeBetweenWatchdogCheckInitial=60000 TransactionInactiveTimeout=60000 #TransactionDeadLockDetectionTimeOut=800000 #TimeBetweenGlobalCheckpoints=1000 #TimeBetweenEpochs=2000 #TimeBetweenEpochsTimeout=4000 HeartbeatIntervalDbDb=15000 HeartbeatIntervalDbApi=15000 MaxNoOfAttributes=10000 MaxNoOfOrderedIndexes=1024 MaxNoOfConcurrentOperations=2000000 #SchedulerSpinTimer=400 #SchedulerExecutionTimer=100 #RealTimeScheduler=1 MaxBufferedEpochs=100 ODirect=1 [NDBD] NodeId=1 HostName=172.20.2.50 DataDir=/home/mysql/cluster/ndb #LockExecuteThreadToCPU=1,2 #LockMaintThreadsToCPU=0 [NDBD] NodeId=2 HostName=172.20.2.56 DataDir=/home/mysql/cluster/ndb #LockExecuteThreadToCPU=1,2 #LockMaintThreadsToCPU=0 [MYSQLD DEFAULT] [MYSQLD] NodeId=50 HostName=172.20.2.50 [MYSQLD] NodeId=54 HostName=172.20.2.56 [API] NodeId=51 HostName=172.20.2.50 [API] NodeId=52 HostName=172.20.2.50 [API] NodeId=55 HostName=172.20.2.56 [API] NodeId=56 HostName=172.20.2.56