MySQL doesn't start with tablespace on OCFS2

[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.
They 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