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

[Pavan Vilas Sondur]

Hi Patrick,
Can you give us the volfiles you are using, log files for all the nodes and any 
other information wrt mysql such as the version, etc. to help us debug the 
problem.

Pavan

On 31/08/09 18:05 +0200, Patrick Matthäi wrote:
> 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!
> ------------------------------------------------------------
> 

> _______________________________________________
> Gluster-devel mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/gluster-devel