- 论坛徽章:
- 0
|
这两天在实验 mysql+drbd+heartbeat
drbd配置已经完成了, 但是加上mysql的话就会出现mysql的权限错误( Mysql的错误代码号 13)
我的实验环境是这样的(虚拟机下,主机的操作系统为slackware 12)
虚拟机: VirutalBox 2.2.4
操作系统: Ubuntu 8.04.1 Server
Mysqld 5.0.51
Drbd 8.0.11
ubutu机和ubuntu2分别安装DRBD8和mysql-server, 两机分别有一块硬盘用于drbd
ubuntu的IP 为 10.9.210.2
ubuntu2的IP为 10.9.210.3
DRBD配置如下:
global { usage-count yes; }
common {
protocol C;
syncer {
rate 10M;
al-extents 257;
}
net {
# cram-hmac-alg sha1;
shared-secret "FooFunFactory";
}
}
resource share {
on ubuntu {
device /dev/drbd0;
disk /dev/sdb1;
address 10.9.210.2:7898;
meta-disk internal;
}
on ubuntu2 {
device /dev/drbd0;
disk /dev/sdb1;
address 10.9.210.3:7898;
meta-disk internal;
}
}
两机上drbd.conf是相同的. 且在两机上分别 drbdadmin create-md share 然后启动drbd; /etc/init.d/drbd start
经验证drbd正常工作
然后, 我打算使用drbd设备来存储/同步Mysql的数据
把ubuntu角色设置为为主机
drbdadm primary share
创建文件系统并挂载
mkfs.ext3 /dev/drbd0
mkdir /mysqldata
mount /dev/drbd0 /mysqldata
Mysql-server是用apt-get 的方式安装的
我把/etc/mysql/my.cnf中的 datadir改为 /mysqldata 然后试着重启mysql 但是mysql启动失败
把 datadir改回默认的/var/lib/mysql, 并把 /mysqldata作软链接到 /var/lib/mysql , 启动mysql也失败
用mysqld_safe --datadir=/mysqldata 启动, 发现下面的错误
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /mysqldata
mysqld_safe[6155]: started
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6165]: ended
用mysqld --datadir=/mysqldata 启动, 错误如下:
090618 12:37:12 [Warning] Can't create test file /mysqldata/ubuntu.lower-test
090618 12:37:12 [Warning] Can't create test file /mysqldata/ubuntu.lower-test
090618 12:37:12 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
把/etc/mysql/my.cnf中的 skip-innodb选项打开, 重新用mysqld --datadir=/mysqldata 启动, 错误如下:
090618 12:40:11 [Warning] Can't create test file /mysqldata/ubuntu.lower-test
090618 12:40:11 [Warning] Can't create test file /mysqldata/ubuntu.lower-test
090618 12:40:11 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
用mysql_install_db命令创建数据库, 错误如下
Installing MySQL system tables...
090618 12:41:12 [Warning] Can't create test file /mysqldata/ubuntu.lower-test
090618 12:41:12 [Warning] Can't create test file /mysqldata/ubuntu.lower-test
ERROR: 1005 Can't create table 'db' (errno: 13)
090618 12:41:12 [ERROR] Aborting
090618 12:41:12 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
所有的提示均显示权限有问题
/mysqldata的权限如下:
drwxr-xr-x mysql mysql mysqldata
已测试过 mysql用户可以些文件夹下新建文件/文件夹
挂载drbd0设备的选项:
/dev/drbd0 on /mysqldata type ext3 (rw)
请高手指点, 或者大家共同讨论 谢谢
[ 本帖最后由 black_fire 于 2009-6-18 16:42 编辑 ] |
|