[gfarm-discuss:08366] Re: SQLite Database in gfarm

[Osamu Tatebe <tatebe@xxxxxxxxxxxxxxxx>]

Hi Sven,

I probably misunderstand your question.  Do you mean you would like
to store sqlite database in Gfarm file system?  Though we do not
try this, it may be stored in Gfarm file system at least when you
use GfarmFS-FUSE.  Possible issue would be how to lock files in
sqlite.  Regarding the system call hook, we need to check whether
it works or not.

Regarding the high reliability, it depends how the database file is
managed by sqlite.  When you use -N option in gfarmfs, the specified
number of file replicas will be automatically created in the
background after the close operation if the file is updated.  If
this helps, Gfarm would support some reliability.

Thanks,
Osamu

On Tue, 17 Apr 2007 09:07:09 +0900
Osamu Tatebe <tatebe@xxxxxxxxxxxxxxxx> wrote:

> Hi Sven,
> 
> sqlite interface is not implemented.  To incorporate the interface,
> metadb_sqlite.c is required after the model of metadb_pgsql.c in
> lib/libgfarm/gfarm directory.  Also, it is necessary to add this
> entry in metadb_sw.[ch] and config.c.
> 
> I guess you probably concern about the performance of PostgreSQL.
> In this case, 'localfs' metadata backend is worth being considered.
> Although config-gfarm does not support this backend, specify a
> directory for this backend by localfs_datadir in gfarm.conf
> like
> 
> localfs_datadir /some/where
> 
> Note that neither postgresql_* nor ldap_* directive should be
> specified.  Moreover, when you use 'localfs' (or 'sqlite' if
> someone contribute a code) metadata backend, gfarm_agent is
> indispensable to share the metadata by several client nodes.
> 
> Thanks,
> Osamu
> 
> On Mon, 16 Apr 2007 17:23:00 +0200
> Sven Dzepina <sd@xxxxxxxxxxxxxxxxxx> wrote:
> 
> > Hello,
> > 
> > is it possible to use a sqlite database in /gfarm ?
> > Does this function without any problems and high reliability?
> > 
> > Greetings,
> > Sven
>