安装mysql-cluster,只起来了一半

wfj0001

报错如下:

mysqld_safe --defaults-file=/data/config/my-node5.cnf --user=mysql &
[2] 19927
[root@rhcsD scripts]# 140513 10:51:13 mysqld_safe Logging to '/mysqlLog/n2_err.log'.
140513 10:51:13 mysqld_safe Starting mysqld daemon with databases from /mysqlData/clusterndb2-data/
140513 10:51:15 mysqld_safe mysqld from pid file /data/socket/n2.pid ended

经过查看日志:

2014-05-13 10:18:31 19606 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exis
t
140513 10:18:31 mysqld_safe mysqld from pid file /data/socket/n2.pid ended

检查mysql.user表:

mysql> select count(*) from mysql.user;
+----------+
| count(*) |
+----------+
|        9 |
+----------+
1 row in set (0.01 sec)


怎么破 ?  

wfj0001

[root@rhcsD local]# ps -ef |grep mysql
root     17615     1  0 09:55 ?        00:00:33 ndb_mgmd -f /data/config/mysqlcluster.ini
root     17631     1  0 09:55 ?        00:00:01 /usr/local/mysql/bin/ndbd --defaults-file=/data/config/my-node4.cnf --initial
root     17632 17631  0 09:55 ?        00:00:45 /usr/local/mysql/bin/ndbd --defaults-file=/data/config/my-node4.cnf --initial
root     17672     1  0 09:56 ?        00:00:01 /usr/local/mysql/bin/ndbd --defaults-file=/data/config/my-node5.cnf --initial
root     17673 17672  0 09:56 ?        00:00:40 /usr/local/mysql/bin/ndbd --defaults-file=/data/config/my-node5.cnf --initial
root     18703 17297  0 10:13 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/config/my-node4.cnf --user=mysql
root     19765 19686  0 10:37 pts/3    00:00:00 mysql -uroot -p -S /data/socket/my-n1.sock
mysql    19860 18703  0 10:42 pts/1    00:00:14 /usr/local/mysql/bin/mysqld --defaults-file=/data/config/my-node4.cnf --basedir=/mysqlData/mysql-cluster --datadir=/mysqlData/clusterndb1-data/ --plugin-dir=/mysqlData/mysql-cluster/lib/plugin --user=mysql --log-error=/mysqlLog/n1_err.log --pid-file=/data/socket/n1.pid --socket=/data/socket/my-n1.sock --port=3399
root     20283 17173  0 11:30 pts/0    00:00:00 grep mysql

进程还差一个 啊 .......

xiaodylan

全部杀掉，重新启动依然报这个么？

wfj0001

我现在是 第一次安装, 全部杀掉, 会有用吗 ?

2818365371

很好！很值得大家参考