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! ------------------------------------------------------------
