[Gluster-users] set volume locking without shutting off server

[Jordan Willis]

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
>