Can SQLite be used with GlusterFS

high-availabilitysqlite

I want to build a distributed storage based on GlusterFS with Automatic File Replication (AFR) to store users files in a fault-tolerant way.

But I also want to access an SQLite3 database stored on the GlusterFS volume (and so replicated on several servers) from multiples clients. Is it possible? Does the concurency between the several clients will be well handled and will not lead to corruption?

Or is there a better alternative to GlusterFS to distribute the SQLite3 database?

Best Answer

GlusterFS supports full POSIX file / record level locking even in replication mode. It should work fine.

Related Solutions

Get sqlite error, “unable to open database file”

Aha, just stumbled across an article explaining this. Also Django have info on their NewbieMistakes page.

The solution is to make sure the directory containing the database file also has write access allowed to the process.

In my case, running this command fixed the problem:

sudo chown www-data .

Rsync / Sqlite database

I would consider this dangerous.

The SQLite database also has journal files that need to be preserved.

If you

rsync the database without the journal files in the middle of a transaction
copy the database file
access the copy

It is highly likely that you will experience corruption.

Use the SQLite Online Backup API instead.

Best Answer

Related Solutions

Get sqlite error, “unable to open database file”

Rsync / Sqlite database

Related Topic