[Gluster-devel] glusterfs 2.0.4 and 2.0.6 are not working very well with mysql

[Patrick Matthäi]

Hello,

I tried to setup a replicate volume for mysql.

Setup:

Fs-1: first storage server
Fs-2: second one

Cluster-1 and cluster-2: same, but they mount the fs- volumes and on both machines should mysql run.

Every server is using Debian Lenny amd64 with the following versions:

ii  fuse-utils                          2.7.4-1.1                Filesystem in USErspace (utilities)
ii  glusterfs-client                    2.0.6-1                  clustered file-system
ii  glusterfs-examples                  2.0.6-1                  example files for the glusterfs server and client
ii  glusterfs-server                    2.0.6-1                  clustered file-system
ii  libfuse2                            2.7.4-1.1                Filesystem in USErspace library
ii  libglusterfs0                       2.0.6-1                  GlusterFS libraries and translator modules

/var/lib/mysql points to the glusterfs mounted /srv/mysql.

Starting mysql on cluster-1 => everything is fine.
Starting mysql on cluster-2 ends up with:

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

Well after some minutes the startup script aborts:

cluster-2:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

cluster-2:~# ps ax|grep mysql
 2729 pts/2    S      0:00 /bin/sh /usr/bin/mysqld_safe
 2769 pts/2    Sl     0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
 2771 pts/2    S      0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
 2944 pts/2    S+     0:00 grep mysql
cluster-2:~# mysql -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Just because mysql didn’t set up the socket (because of the previous failure).

I read the thread „mysql on glusterfs“, where ist he same error with an much older version which was fixed, but now here it is broken.

I Hope you can help ☺


-------

Mit freundlichen Grüßen / Best regards

Patrick Matthäi

LPI-zertifizierter Linux Administrator
GNU/Linux Debian Developer
 Technik

ameus GmbH
Stettiner Straße 24
33106 Paderborn
Tel: 05251-14807-20
Fax: 05251-14807-30
HRB 8694 AG Paderborn
Geschäftsführer: Stephan Winter
------------------------------------------------------------
MEiM 2009 - Lernen Sie Ameus persönlich kennen!
Die Kongressmesse für Entscheider in Paderborn
Die Teilnahmegebühr von 149€ übernehmen wir für Sie
Anmeldung unter www.meim.de<http://www.meim.de/> - Buchungscode: AHGA9TF
Unser Vortrag: Erfolgreiche Online-Verkäufe!
------------------------------------------------------------