Comments on Installing A Web, Email And MySQL Database Cluster (Mirror) On Debian 5.0 With ISPConfig 3

All,

After I followed this post for creating mirror ispconfig, the glusterfs-server will not work normally to mount the volume.  I added following line to fstab and run " mount -a". It is fine to mount the volume. After I restart the server, the volumes will not be mount and show "transport endpoint is not connected gluster" with df command show.

/etc/glusterfs/glusterfs-mysql.vol  /var/lib/mysql  glusterfs  defaults  0  0
/etc/glusterfs/glusterfs-vmail.vol  /var/vmail  glusterfs  defaults  0  0
/etc/glusterfs/glusterfs-www.vol  /var/www  glusterfs  defaults  0  0

Anyone can help to solve the problem.

you have found a solution. as I feel the same

As Fuse is not launched at boot time, gluster can't mount FS. To make it work, just add line fuse in /etc/modules.

cf. : http://asaclue.wordpress.com/2011/03/26/mount-glusterfs-volume-at-boot-time-in-ubuntu-lucid-10-04/

I second that motion.

Too bad I didnt see your comment before I figured it out :)

apt-get clean

 and the solved problem to me :)

Hi Till

Thanks for this great tutorial. 

Regarding the Boot order of Glusterfs, I think that the line 

 mv /etc/rc2.d/S20glusterfs-server /etc/rc2.d/S19glusterfs-server

should have been 

 mv /etc/rc2.d/S20glusterfs-server /etc/rc2.d/S16glusterfs-server

thanks

nano /etc/apt/sources.list

Aktuell:

deb http://volatile.debian.org/debian-volatile lenny/volatile main contrib non-free
deb http://backports.debian.org/debian-backports lenny-backports main

In the file /etc/fstab it should be included _netdev 

Eg

 /etc/glusterfs/glusterfs-mysql.vol  /var/lib/mysql  glusterfs  defaults,_netdev  0  0

/etc/glusterfs/glusterfs-vmail.vol  /var/vmail  glusterfs  defaults,_netdev  0  0

/etc/glusterfs/glusterfs-www.vol  /var/www  glusterfs  defaults,_netdev  0  0

This is necessary because otherwise the volumes would not start automatically when the server restarts.

Hi and thank's for this howto.
I have a Problem where i have to start the Slave-server's MySQL Server!

I've modified the /etc/mysql/debian.cnf file on the Slave-Server
-> replaced the original Content with the Master-Server's content

Now start the services again:
/etc/init.d/mysql start
...

root@L-SRV-2:/tmp# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

nano /var/log/syslog says:
Sep 15 23:03:40 L-SRV-2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [Note] Plugin 'FEDERATED' is disabled.
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [Note] Plugin 'InnoDB' is disabled.
Sep 15 23:03:40 L-SRV-2 mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Sep 15 23:03:40 L-SRV-2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!


Where is the Problem?
I googled around and couldn't find any helping posts.

Thank's for y'all help.
AlexGer83

I had a similar problem, it would be two tips.
1: use Wheezy packages. I found bugs in Squeeze.
2: permissions - for example, the MySQL UID/GID are differents on the 2 servers.

Please do not follow this tutorial for setting up GlusterFS.

The instructions here are for version 2.0. At the time of this comment, 3.3 has been released and does not require the editing of any .vol files.

This tutorial is for Debian Lenny, and Lenny comes (came) with GlusterFS 2. Therefore these instructions are fine.