DDM之myql cluster

PSjamsBond-0-0-0:/root-# cat /DDM_SUBTREE/usr/dhafw/data/mysql/config.ini
# file "config.ini" - showing minimal setup with 1 DB node
# This file is placed in the start directory of ndb_mgmd,
# the management server.

# 09-02-2012 FV CRI # 00633278.01  : ACOS #54804 : db status is always KOM after using WA in ticket 54582

[API DEFAULT]

[TCP DEFAULT]
#PortNumber: 28002

SendBufferMemory = 3M
[NDB_MGMD DEFAULT]
PortNumber = 2200
DataDir=/var/local/nectar/log

[NDB_MGMD]
id=1
hostname=STATION_A
ArbitrationRank: 1

[NDBD DEFAULT]
ServerPort = 28002
DataDir=/user/database/log
#DataDir=/var/local/nectar/log/
NoOfReplicas = 1
DataMemory = 5000M
IndexMemory = 650M
MaxLCPStartDelay: 300
MaxNoOfSavedMessages: 5
MaxNoOfSubscriptions: 2000
MaxNoOfSubscribers: 4000
LockPagesInMainMemory: 2
#StartPartialTimeout: 10000
StartPartitionedTimeout: 60000
StartFailureTimeout: 0
HeartbeatIntervalDbDb:  3000
HeartbeatIntervalDbApi: 3000
ArbitrationTimeout: 30000
MaxNoOfOrderedIndexes: 500
MaxNoOfTables = 1000
MaxNoOfUniqueHashIndexes: 500
MaxNoOfAttributes:  5000
MaxNoOfTriggers: 2000
TimebetweenLocalCheckpoints: 20
TimebetweenGlobalCheckpoints: 2000
#TransactionInactiveTimeout: 0
TransactionDeadlockDetectionTimeout = 1000
TransactionInactiveTimeout: 500000
TimeBetweenInactiveTransactionAbortCheck: 1500
NoOfFragmentLogFiles = 16
InitFragmentLogFiles=full
LogLevelStartup: 15
LogLevelShutdown: 15
LogLevelConnection: 15
LogLevelInfo: 15
LogLevelError: 15
LogLevelNodeRestart: 15
LogLevelCheckpoint: 1
StopOnError: Y
DiskCheckpointSpeed=4M
ODirect=1

MaxNoOfConcurrentOperations = 65000
FragmentLogFileSize = 256M
StartPartialTimeout = 30000
[NDBD]
id=3
hostname=STATION_A
FileSystemPath: /user/database/ndbd

[MYSQLD]
id=7
hostname=STATION_A

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

 

 

PSjamsBond-0-0-0:/root-# ddmEnv
PSjamsBond-0-0-0:/root-# ndb_mgm
-- NDB Cluster -- Management Client --

 

 

PSjamsBond-0-0-0:/root-# ddmEnv
PSjamsBond-0-0-0:/root-# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show;
Connected to Management Server at: STATION_A:2200
Cluster Configuration
---------------------
[ndbd(NDB)]     1 node(s)
id=3    @169.254.200.1  (mysql-5.1.61 ndb-7.1.22, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @169.254.200.1  (mysql-5.1.61 ndb-7.1.22)

[mysqld(API)]   235 node(s)
id=7    @169.254.200.1  (mysql-5.1.61 ndb-7.1.22)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)
id=13 (not connected, accepting connect from any host)
id=14 (not connected, accepting connect from any host)
id=15 (not connected, accepting connect from any host)
id=16 (not connected, accepting connect from any host)
id=17 (not connected, accepting connect from any host)
id=18 (not connected, accepting connect from any host)
id=19 (not connected, accepting connect from any host)
id=20 (not connected, accepting connect from any host)
id=21 (not connected, accepting connect from any host)
id=22 (not connected, accepting connect from any host)
id=23 (not connected, accepting connect from any host)
id=24 (not connected, accepting connect from any host)
id=25 (not connected, accepting connect from any host)
id=26 (not connected, accepting connect from any host)
id=27 (not connected, accepting connect from any host)
id=28 (not connected, accepting connect from any host)
id=29 (not connected, accepting connect from any host)
id=30 (not connected, accepting connect from any host)
id=31 (not connected, accepting connect from any host)
id=32 (not connected, accepting connect from any host)
id=33 (not connected, accepting connect from any host)
id=34 (not connected, accepting connect from any host)
id=35 (not connected, accepting connect from any host)
id=36 (not connected, accepting connect from any host)
id=37 (not connected, accepting connect from any host)
id=38 (not connected, accepting connect from any host)
id=39 (not connected, accepting connect from any host)
id=40 (not connected, accepting connect from any host)
id=41 (not connected, accepting connect from any host)
id=42 (not connected, accepting connect from any host)
id=43 (not connected, accepting connect from any host)
id=44 (not connected, accepting connect from any host)
id=45 (not connected, accepting connect from any host)
id=46 (not connected, accepting connect from any host)
id=47 (not connected, accepting connect from any host)
id=48 (not connected, accepting connect from any host)
id=49 (not connected, accepting connect from any host)
id=50 (not connected, accepting connect from any host)
id=51 (not connected, accepting connect from any host)
id=52 (not connected, accepting connect from any host)
id=53 (not connected, accepting connect from any host)
id=54 (not connected, accepting connect from any host)
id=55 (not connected, accepting connect from any host)
id=56 (not connected, accepting connect from any host)
id=57 (not connected, accepting connect from any host)
id=58 (not connected, accepting connect from any host)
id=59 (not connected, accepting connect from any host)
id=60 (not connected, accepting connect from any host)
id=61 (not connected, accepting connect from any host)
id=62 (not connected, accepting connect from any host)
id=63 (not connected, accepting connect from any host)
id=64 (not connected, accepting connect from any host)
id=65 (not connected, accepting connect from any host)
id=66 (not connected, accepting connect from any host)
id=67 (not connected, accepting connect from any host)
id=68 (not connected, accepting connect from any host)
id=69 (not connected, accepting connect from any host)
id=70 (not connected, accepting connect from any host)
id=71 (not connected, accepting connect from any host)
id=72 (not connected, accepting connect from any host)
id=73 (not connected, accepting connect from any host)
id=74 (not connected, accepting connect from any host)
id=75 (not connected, accepting connect from any host)
id=76 (not connected, accepting connect from any host)
id=77 (not connected, accepting connect from any host)
id=78 (not connected, accepting connect from any host)
id=79 (not connected, accepting connect from any host)
id=80 (not connected, accepting connect from any host)
id=81 (not connected, accepting connect from any host)
id=82 (not connected, accepting connect from any host)
id=83 (not connected, accepting connect from any host)
id=84 (not connected, accepting connect from any host)
id=85 (not connected, accepting connect from any host)
id=86 (not connected, accepting connect from any host)
id=87 (not connected, accepting connect from any host)
id=88 (not connected, accepting connect from any host)
id=89 (not connected, accepting connect from any host)
id=90 (not connected, accepting connect from any host)
id=91 (not connected, accepting connect from any host)
id=92 (not connected, accepting connect from any host)
id=93 (not connected, accepting connect from any host)
id=94 (not connected, accepting connect from any host)
id=95 (not connected, accepting connect from any host)
id=96 (not connected, accepting connect from any host)
id=97 (not connected, accepting connect from any host)
id=98 (not connected, accepting connect from any host)
id=99 (not connected, accepting connect from any host)
id=100 (not connected, accepting connect from any host)
id=101 (not connected, accepting connect from any host)
id=102 (not connected, accepting connect from any host)
id=103 (not connected, accepting connect from any host)
id=104 (not connected, accepting connect from any host)
id=105 (not connected, accepting connect from any host)
id=106 (not connected, accepting connect from any host)
id=107 (not connected, accepting connect from any host)
id=108 (not connected, accepting connect from any host)
id=109 (not connected, accepting connect from any host)
id=110 (not connected, accepting connect from any host)
id=111 (not connected, accepting connect from any host)
id=112 (not connected, accepting connect from any host)
id=113 (not connected, accepting connect from any host)
id=114 (not connected, accepting connect from any host)
id=115 (not connected, accepting connect from any host)
id=116 (not connected, accepting connect from any host)
id=117 (not connected, accepting connect from any host)
id=118 (not connected, accepting connect from any host)
id=119 (not connected, accepting connect from any host)
id=120 (not connected, accepting connect from any host)
id=121 (not connected, accepting connect from any host)
id=122 (not connected, accepting connect from any host)
id=123 (not connected, accepting connect from any host)
id=124 (not connected, accepting connect from any host)
id=125 (not connected, accepting connect from any host)
id=126 (not connected, accepting connect from any host)
id=127 (not connected, accepting connect from any host)
id=128 (not connected, accepting connect from any host)
id=129 (not connected, accepting connect from any host)
id=130 (not connected, accepting connect from any host)
id=131 (not connected, accepting connect from any host)
id=132 (not connected, accepting connect from any host)
id=133 (not connected, accepting connect from any host)
id=134 (not connected, accepting connect from any host)
id=135 (not connected, accepting connect from any host)
id=136 (not connected, accepting connect from any host)
id=137 (not connected, accepting connect from any host)
id=138 (not connected, accepting connect from any host)
id=139 (not connected, accepting connect from any host)
id=140 (not connected, accepting connect from any host)
id=141 (not connected, accepting connect from any host)
id=142 (not connected, accepting connect from any host)
id=143 (not connected, accepting connect from any host)
id=144 (not connected, accepting connect from any host)
id=145 (not connected, accepting connect from any host)
id=146 (not connected, accepting connect from any host)
id=147 (not connected, accepting connect from any host)
id=148 (not connected, accepting connect from any host)
id=149 (not connected, accepting connect from any host)
id=150 (not connected, accepting connect from any host)
id=151 (not connected, accepting connect from any host)
id=152 (not connected, accepting connect from any host)
id=153 (not connected, accepting connect from any host)
id=154 (not connected, accepting connect from any host)
id=155 (not connected, accepting connect from any host)
id=156 (not connected, accepting connect from any host)
id=157 (not connected, accepting connect from any host)
id=158 (not connected, accepting connect from any host)
id=159 (not connected, accepting connect from any host)
id=160 (not connected, accepting connect from any host)
id=161 (not connected, accepting connect from any host)
id=162 (not connected, accepting connect from any host)
id=163 (not connected, accepting connect from any host)
id=164 (not connected, accepting connect from any host)
id=165 (not connected, accepting connect from any host)
id=166 (not connected, accepting connect from any host)
id=167 (not connected, accepting connect from any host)
id=168 (not connected, accepting connect from any host)
id=169 (not connected, accepting connect from any host)
id=170 (not connected, accepting connect from any host)
id=171 (not connected, accepting connect from any host)
id=172 (not connected, accepting connect from any host)
id=173 (not connected, accepting connect from any host)
id=174 (not connected, accepting connect from any host)
id=175 (not connected, accepting connect from any host)
id=176 (not connected, accepting connect from any host)
id=177 (not connected, accepting connect from any host)
id=178 (not connected, accepting connect from any host)
id=179 (not connected, accepting connect from any host)
id=180 (not connected, accepting connect from any host)
id=181 (not connected, accepting connect from any host)
id=182 (not connected, accepting connect from any host)
id=183 (not connected, accepting connect from any host)
id=184 (not connected, accepting connect from any host)
id=185 (not connected, accepting connect from any host)
id=186 (not connected, accepting connect from any host)
id=187 (not connected, accepting connect from any host)
id=188 (not connected, accepting connect from any host)
id=189 (not connected, accepting connect from any host)
id=190 (not connected, accepting connect from any host)
id=191 (not connected, accepting connect from any host)
id=192 (not connected, accepting connect from any host)
id=193 (not connected, accepting connect from any host)
id=194 (not connected, accepting connect from any host)
id=195 (not connected, accepting connect from any host)
id=196 (not connected, accepting connect from any host)
id=197 (not connected, accepting connect from any host)
id=198 (not connected, accepting connect from any host)
id=199 (not connected, accepting connect from any host)
id=200 (not connected, accepting connect from any host)
id=201 (not connected, accepting connect from any host)
id=202 (not connected, accepting connect from any host)
id=203 (not connected, accepting connect from any host)
id=204 (not connected, accepting connect from any host)
id=205 (not connected, accepting connect from any host)
id=206 (not connected, accepting connect from any host)
id=207 (not connected, accepting connect from any host)
id=208 (not connected, accepting connect from any host)
id=209 (not connected, accepting connect from any host)
id=210 (not connected, accepting connect from any host)
id=211 (not connected, accepting connect from any host)
id=212 (not connected, accepting connect from any host)
id=213 (not connected, accepting connect from any host)
id=214 (not connected, accepting connect from any host)
id=215 (not connected, accepting connect from any host)
id=216 (not connected, accepting connect from any host)
id=217 (not connected, accepting connect from any host)
id=218 (not connected, accepting connect from any host)
id=219 (not connected, accepting connect from any host)
id=220 (not connected, accepting connect from any host)
id=221 (not connected, accepting connect from any host)
id=222 (not connected, accepting connect from any host)
id=223 (not connected, accepting connect from any host)
id=224 (not connected, accepting connect from any host)
id=225 (not connected, accepting connect from any host)
id=226 (not connected, accepting connect from any host)
id=227 (not connected, accepting connect from any host)
id=228 (not connected, accepting connect from any host)
id=229 (not connected, accepting connect from any host)
id=230 (not connected, accepting connect from any host)
id=231 (not connected, accepting connect from any host)
id=232 (not connected, accepting connect from any host)
id=233 (not connected, accepting connect from any host)
id=234 (not connected, accepting connect from any host)
id=235 (not connected, accepting connect from any host)
id=236 (not connected, accepting connect from any host)
id=237 (not connected, accepting connect from any host)
id=238 (not connected, accepting connect from any host)
id=239 (not connected, accepting connect from any host)
id=240 (not connected, accepting connect from any host)
id=241 (not connected, accepting connect from any host)

ndb_mgm>