[OpenAFS] Shared r/w access to numerous sqlite databases: an appropriate application for AFS?

Matt W. Benjamin matt@linuxbox.com
Thu, 8 Apr 2010 14:18:13 -0400 (EDT)


Simon is correct.  A byte-range locking implementation for OpenAFS is being funded by Your File System, Inc., under its DOE SBIR Phase II grant.  As stated elsewhere by Jeff, there are (or will be) structures for making completed available to the community during the course of the work.

However, my understanding that shared r/w access to sqlite through AFS probably does work, provided you ensure sqlite uses the correct locking style (cf. sqlite's os_unix.c):

#define SQLITE_WHOLE_FILE_LOCKING  0x0001   /* Use whole-file locking */

This feature is apparently due to Adam Megacz, who posted briefly about it in 2006.  See http://marc.info/?l=sqlite-users&m=116742195016159&w=2 .



----- "Simon Wilkinson" <sxw@inf.ed.ac.uk> wrote:

> On 8 Apr 2010, at 12:22, Todd Lewis wrote:

> Someone (Matt, IIRC) was working on server support for byte range  
> locking, but I don't think we've seen any code yet.
> Cheers,
> Simon.


Matt Benjamin

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104


tel. 734-761-4689
fax. 734-769-8938
cel. 734-216-5309