Gluster users - Jul 2015 - set volume locking without shutting off server

Looks like upgrading to the latest version of glusterfs solved all my locking
issues.

Thank you,
Jordan
> On Jul 4, 2015, at 3:22 AM, Jordan Willis <jwillis0720 at gmail.com>
wrote:
> 
> Its not just sqlite, but mongodb and ipython notebook. If you have a
solution for mongodb file locking, I?m welcome to suggestions. But not using
mongodb, is not an option.
> 
>> On Jul 4, 2015, at 2:57 AM, Niels de Vos <ndevos at redhat.com>
wrote:
>> 
>> On Fri, Jul 03, 2015 at 06:46:01PM -0700, Jordan Willis wrote:
>>> Hi,
>>> 
>>> Is it possible to enable posix type locking with glusterfs without
>>> shutting off the volume?
>> 
>> Locking should be enabled by default (like Kaushal explained in an
other
>> reply).
>> 
>>> I think this is what I need (I?m trying to get sqlite to lock files
on
>>> my nfs mounted glusterfs volume)
>> 
>> SQLite is not the best databases to place on a shared filesystem. The
>> locking done by SQLite is (or at least was, might have changed) not
very
>> advanced. From what I remember, there is a single file lock, no table
or
>> row granularity.
>> 
>> https://www.sqlite.org/pragma.html#pragma_locking_mode contains some
>> more details, and it also points to the WAL documentation. You will
want
>> to prevent SQLite to use shared-memory for WAL if you access the
>> database from different servers at the same time.
>> 
>> HTH,
>> Niels
>

On Sat, Jul 04, 2015 at 08:10:48PM -0700, Jordan Willis
wrote:
> Looks like upgrading to the latest version of glusterfs solved all my
> locking issues. 
Thanks for reporting back.

I'm not aware of any changes related to locking since 3.5.2 (was it?).
That makes it difficult to guess what the problem caused and why it
works fine with an updated version.

Have a good weekend,
Niels
> 
> Thank you,
> Jordan
> 
> > On Jul 4, 2015, at 3:22 AM, Jordan Willis <jwillis0720 at
gmail.com> wrote:
> > 
> > Its not just sqlite, but mongodb and ipython notebook. If you have a
solution for mongodb file locking, I?m welcome to suggestions. But not using
mongodb, is not an option.
> > 
> >> On Jul 4, 2015, at 2:57 AM, Niels de Vos <ndevos at
redhat.com> wrote:
> >> 
> >> On Fri, Jul 03, 2015 at 06:46:01PM -0700, Jordan Willis wrote:
> >>> Hi,
> >>> 
> >>> Is it possible to enable posix type locking with glusterfs
without
> >>> shutting off the volume?
> >> 
> >> Locking should be enabled by default (like Kaushal explained in an
other
> >> reply).
> >> 
> >>> I think this is what I need (I?m trying to get sqlite to lock
files on
> >>> my nfs mounted glusterfs volume)
> >> 
> >> SQLite is not the best databases to place on a shared filesystem.
The
> >> locking done by SQLite is (or at least was, might have changed)
not very
> >> advanced. From what I remember, there is a single file lock, no
table or
> >> row granularity.
> >> 
> >> https://www.sqlite.org/pragma.html#pragma_locking_mode contains
some
> >> more details, and it also points to the WAL documentation. You
will want
> >> to prevent SQLite to use shared-memory for WAL if you access the
> >> database from different servers at the same time.
> >> 
> >> HTH,
> >> Niels
> > 
>