[Ocfs2-users] MySQL ISAM can't start from OCFS2 filesystem

[Marco Fischer]

Hello friends,

 

I've got a strange problem with my cluster-setup.

 

I've got two nodes called www1 and www2 running Ubuntu Linux 8.10.

 

The have a 50G volume which is replicated in primary/primary mode with
DRBD.

 

On this volume there is an OCSF2 filesystem with this two nodes.

 

Everything is working really fine, files are perfectly mirrored, really
nice.

 

On one of the two nodes, I want to run MySQL. But...

 

When I move the MySQL data directory to the OCFS2 filesystem, MySQL is
unable to start. Filepermissions are fine, and when I su to user mysql I
can write to the OCFS2 without problems. MySQL stops with the following
error message:

 

090323 12:11:50 [Warning] Can't create test file
/clusterfs/mysql/www1.lower-test

090323 12:11:50 [Warning] Can't create test file
/clusterfs/mysql/www1.lower-test

mysqld: File '/clusterfs/log/www1/mysql/mysql.log' not found (Errcode:
13)

090323 12:11:50 [ERROR] Could not use
/clusterfs/log/www1/mysql/mysql.log for logging (error 13). Turning
logging off for the whole duration of the MySQL server process. To turn
it on again: fix the cause, shutdown the MySQL server and restart it.

090323 12:11:50  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: 'open'.

InnoDB: Cannot continue operation.

 

I don't understand where the problem is. 

 

Interesting is that MySQL did not find the file
"/clusterfs/log/www1/mysql/mysql.log" which is in the filesystem and
chmodded 777 for sure.

 

There are whitepapapers on MySQL.com which describe my setup as a
working MySQL active/passive cluster setup.

 

Please help me out!

 

Kind regards 

 

Marco

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/ocfs2-users/attachments/20090323/419367dd/attachment.html