[Pacemaker] MySQL startup slow on OCFS2

[Lars Marowsky-Bree]

On 2010-05-26T10:26:35, daniel qian <daniel at bestningning.com> wrote:

> I followed this link to setup a two-node cluster on Ubuntu 10.4 - https://wiki.ubuntu.com/ClusterStack/LucidTesting#Pacemaker,%20drbd8%20and%20OCFS2%20or%20GFS2
> 
> Everything is working fine except for running MySQL on both nodes with MySQL datadir set to the drbd based OCFS2 disk space.  Everytime I run command 'service mysql start'  on the second node to start up MySQL it takes a much longer time than it does on the first one to start. I tried changing the order of the two nodes to start MySQL it is always the node that starts the second MySQL. 
> 
> I set apparmor for msyqld to complain mode and noticed a lot of these lines being produced in /var/log/syslog during the delay:

Does it go faster if you disable apparmor for the test?

> Does anyone know what is going on here with mysql?

How much slower is "slower"? OCFS2 obviously introduces some overhead if
you have lock contention (ie, trying to modify the same file system
objects, such as a directory).

Which versions? How are you controlling ocfs2?


Regards,
    Lars

-- 
Architect Storage/HA, OPS Engineering, Novell, Inc.
SUSE LINUX Products GmbH, GF: Markus Rex, HRB 16746 (AG Nürnberg)
"Experience is the name everyone gives to their mistakes." -- Oscar Wilde