[Gluster-users] Lock error with mysql over gluster

Martí­n Eduardo Bradaschia martin.bradaschia at intercomgi.net
Wed Mar 24 14:19:20 UTC 2010


Hi

I have a production environment like this:  Debian Etch (4.0), ext3, 
glusterfs-2.0.9 (built from LATEST src), fuse-2.7.4glfs11, mysql 5.1.

When I restart mysql it fiils the syslog with messages like this:

InnoDB: Unable to lock ./ibdata1, error: 11

I tried next translator variations:

type features/posix-locks
type features/locks
option mandatory-locks on

even with mysql restart gluster

... the same problem once and again

Can anybody help me ? Thanx in advance !

Here my current configuration:

----------- Sever

volume posix1
type storage/posix
option directory /media/vol1
option background-unlink yes       end-volume

volume locks1
type features/posix-locks
option mandatory-locks on
subvolumes posix1
end-volume

volume brick1
type performance/io-threads
option thread-count 8            # Default es 16
subvolumes locks1
end-volume

volume posix2
type storage/posix
option directory /media/vol2
option background-unlink yes       end-volume

volume locks2
type features/posix-locks
option mandatory-locks on
subvolumes posix2
end-volume

volume brick2
type performance/io-threads
option thread-count 8            # Default es 16
subvolumes locks2
end-volume

volume server1
type protocol/server
option transport-type tcp
option transport.socket.bind-address 127.0.0.1
option transport.socket.listen-port 7001        # Default is 6996
option auth.addr.brick1.allow *           subvolumes brick1
end-volume


volume server2
type protocol/server
option transport-type tcp
option transport.socket.bind-address 127.0.0.1
option transport.socket.listen-port 7002        # Default is 6996
option auth.addr.brick2.allow *           subvolumes brick2
end-volume

----------- Client


volume client1
type protocol/client
option transport-type tcp
option remote-host 127.0.0.1        # El servidor es local
option remote-port 7001        # Defalut is 6995
option remote-subvolume brick1    # name of the remote volume
end-volume


volume client2
type protocol/client
option transport-type tcp
option remote-host 127.0.0.1       option remote-port 7002        # 
Defalut is 6995
option remote-subvolume brick2    # name of the remote volume
end-volume


volume completo
type cluster/distribute
option min-free-disk 20%
subvolumes client1 client2
end-volume


volume writebehind
type performance/write-behind
option cache-size 4MB
subvolumes completo
end-volume

volume iocache
type performance/io-cache
option cache-size 64MB
subvolumes writebehind
end-volume

-- 
Martin Eduardo Bradaschia
Intercomgi Argentina 
 




More information about the Gluster-users mailing list