MariaDB社区

标题: 安装集群配置成功但现在各sql数据库服务不能启动 [打印本页]

作者: liyihongcug 时间: 2009-6-5 13:32
标题: 安装集群配置成功但现在各sql数据库服务不能启动
安装集群配置成功但现在各sql数据库服务不能启动

我安装了server
client
和
storage  engine
storage  engine management
storage  engine tool
配置成功可以 ndb—mgm  show
可以看到各节点

但是在一个 node上不能启动 mysql服务  不知道什么原因

提示信息如下
[root@localhost mysql]# ./bin/mysqld_safe &
[2] 3275
[root@localhost mysql]# bash: ./bin/mysqld_safe: No such file or directory

[2]-  Exit 127             ./bin/mysqld_safe
[root@localhost mysql]# ./bin/mysqld_safe &
[2] 3276
[root@localhost mysql]# bash: ./bin/mysqld_safe: No such file or directory

[2]-  Exit 127             ./bin/mysqld_safe
[root@localhost mysql]# starting mysqld daemon with databases from /home/zzx2/mysql/data

[root@localhost mysql]# bash: ./bin/mysqld_safe: 没有那个文件或目录

[1]+  Exit 127             ./bin/mysqld_safe
[root@localhost mysql]# Starting mysqld daemon with database from /home/zzx2/mysql/data
bash: Starting: command not found
[root@localhost mysql]#
[root@localhost mysql]#

bash: starting: command not found
[root@localhost mysql]#

这里  ./bin/mysqld_safe &  不知道什么意思，为什么以一定要这样。

现在用另外命令service mysql start 启动
在从机器上是成功的俄
但是在主机器上提示如下错误：
starting mysql ......manger of pid-file quit without updating {failure}

log  error like this:

090604 21:26:32 mysqld_safe Starting mysqld daemon with databases from /home/zzx2/mysql/data
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090604 21:26:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090604 21:26:33  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090604 21:26:33 mysqld_safe mysqld from pid file /home/zzx2/mysql/data/localhost.localdomain.pid endedv

作者: admin 时间: 2009-6-17 10:01
一看就知道你看的是“深入浅出”那本书吧
你的MySQL是用rpm还是二进制安装的？

检查：
环境变量没有配置好，找不到文件
还有就是mysql系统库，没有正确生成。

参考：
http://www.mysqlpub.com/viewthread.php?tid=331&extra=page%3D1

欢迎光临 MariaDB社区 (http://123.56.88.72/)