[root@mysqlclu08 bin]# mysqld_safe
140610 18:48:09 mysqld_safe Logging to '/usr/local/mysql/data/mysqlclu08.err'.
140610 18:48:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140610 18:48:14 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqlclu08.pid ended
查看启动日志:
[root@mysqlclu08 bin]# cat /usr/local/mysql/data/mysqlclu08.err
140610 18:48:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140610 18:48:09 InnoDB: Initializing buffer pool, size = 8.0M
140610 18:48:09 InnoDB: Completed initialization of buffer pool
140610 18:48:09 InnoDB: Started; log sequence number 0 1626124
140610 18:48:09 [ERROR] /usr/libexec/mysqld: unknown option '--ndbcluster'
140610 18:48:09 [ERROR] Aborting
140610 18:48:09 InnoDB: Starting shutdown...
140610 18:48:14 InnoDB: Shutdown completed; log sequence number 0 1626124
140610 18:48:14 [Note] /usr/libexec/mysqld: Shutdown complete
140610 18:48:14 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqlclu08.pid ended
报错[ERROR] /usr/libexec/mysqld: unknown option '--ndbcluster' 选线未知,怎么就未知了呢!
sql节点配置文件:
[root@mysqlclu08 ~]# cat /etc/my.cnf
[mysqld]
ndbcluster
#skip-ndbcluster
datadir=/usr/local/mysql/data
[mysql_cluster]
ndb-connectstring=132.228.25.58
[root@mysqlclu08 ~]#
应该就是
[mysqld]
ndbcluster
配的这个导致的问题,但是注释掉了仍然会报别的问题。
管理节点:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @132.228.25.56 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
id=3 @132.228.25.59 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @132.228.25.58 (mysql-5.6.17 ndb-7.3.5)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 132.228.25.55)
id=5 (not connected, accepting connect from 132.228.25.57)
ndb_mgm>
显示sql节点未连上。
管理节点配置文件:
ndb_1_cluster.log ndb_1_out.log ndb_1.pid ndb_mgm ndb_mgmd
[root@mysqlclu09 bin]# cat /var/lib/mysql-cluster/config.ini
[ndbd default]
NoOfReplicas=2
datadir=/usr/local/mysql/data
DataMemory=80M
IndexMemory=18M
[ndb_mgmd]
hostname=132.228.25.58
[ndbd]
hostname=132.228.25.56
[ndbd]
hostname=132.228.25.59
[mysqld]
hostname=132.228.25.55
[mysqld]
hostname=132.228.25.57
[root@mysqlclu09 bin]#
搞崩溃了。
情况是这样滴,本来昨天装上了两个sql节点都是连上过的,但是今天来的时候我把集群关闭了,在起的时候就报错,sql节点怎么都起不来。求各位遇到过的大神给看看,本人不胜感激!
1 个解决方案
#1
加一句,我是kill -9把sql节点的进程给杀掉的。
#1
加一句,我是kill -9把sql节点的进程给杀掉的。