【讨论中】请教 mysql cluster 数据节点 起不来 自动down

xGss2000

2012-09-05 13:01:36 [MgmtSrvr] INFO     -- Nodeid 3 allocated for NDB at 127.0.0.1
2012-09-05 13:01:36 [MgmtSrvr] INFO     -- Node 1: Node 3 Connected
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Start phase 0 completed
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Communication to Node 4 opened
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Start potentially partitioned with nodes 3  [ missing: 4 no-wait: 4 ]
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: CM_REGCONF president = 3, own Node = 3, our dynamic id = 0/1
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Start phase 1 completed
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Start phase 2 completed (system restart)
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Start phase 3 completed (system restart)
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Restarting cluster to GCI: 262
2012-09-05 13:01:38 [MgmtSrvr] INFO     -- Node 3: Starting to restore schema
2012-09-05 13:01:38 [MgmtSrvr] ALERT    -- Node 3: Forced node shutdown completed. Occured during startphase 4. Caused by error 2355: 'Failure to restore schema(Resource configuration error). Permanent error, external action needed'.
2012-09-05 13:01:39 [MgmtSrvr] ALERT    -- Node 1: Node 3 Disconnected

xGss2000

版本信息

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @127.0.0.1  (mysql-5.5.25 ndb-7.2.7, starting, Nodegroup: 0)
id=4 (not connected, accepting connect from localhost)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @127.0.0.1  (mysql-5.5.25 ndb-7.2.7)

[mysqld(API)]   1 node(s)
id=50 (not connected, accepting connect from any host)

管理节点，数据节点，sql节点都在一台机器

xGss2000

config.ini

[ndb_mgmd]
hostname=localhost
datadir=/state/partition1/cluster_data/ndb_data
NodeId=1
[ndbd default]
noofreplicas=2
datadir=/state/partition1/cluster_data/ndb_data
DataMemory: 4000M
IndexMemory: 500M
MaxNoOfConcurrentTransactions:4096
MaxNoOfConcurrentOperations:500000
MaxNoOfLocalOperations:550000
MaxNoOfAttributes: 10000
MaxNoOfTables: 3000
MaxNoOfOrderedIndexes: 3000
MaxNoOfUniqueHashIndexes: 3000
MaxNoOfTriggers: 500
TransactionDeadlockDetectionTimeout: 60000
[ndbd]
hostname=localhost
NodeId=3
[ndbd]
hostname=localhost
NodeId=4
[mysqld]
NodeId=50

xGss2000

my.cnf

[mysqld]
default-storage-engine=NDB
ndbcluster
datadir=/state/partition1/cluster_data/mysqld_data
basedir=/home/mysqlCluster/mysql/mysqlc
port=5000
#skip-grant-tables
skip-name-resolve
lower_case_table_names=1
max_connections=2000
thread_cache_size=50
innodb_buffer_pool_size=500M
character-set-server=utf8
innodb_lock_wait_timeout=600
#innodb_data_file_path = ibdata1:1000M:autoextend

xGss2000

顶顶！！！！

xGss2000

kerlion 发表于 2012-09-06 10:47
节点3,4同时启动

还是不行，都报错