Niels de Vos
2015-Jul-04 09:57 UTC
[Gluster-users] set volume locking without shutting off server
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
Jordan Willis
2015-Jul-04 10:22 UTC
[Gluster-users] set volume locking without shutting off server
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