Shared DB

[thielj]

Hi

Can multiple instances of LLDAP share the same SQLite database through a shared volume or network drive?

How is the situation when using a shared Postgres DB?

It would be sufficient if one LLDAP is used as a "master" to make modifications and the others are used as read-only.

[jakob42]

I'm using sqlite, inotify and rsync. It's a cursed setup that works so far. 🫣

[jakob42]

But I'm fully aware that there is no support for my setup

[nitnelave]

That's a bit of a risky setup, but as long as you don't have concurrent writes, it should be fine.

[jakob42]

Sorry, forgot to mention, I only sync from one server to the two others.

And yeah, I bet it's risky, but it worked for about 6 month now.

[nitnelave]

If you only sync one way, it should be safe (though you of course lose the writes on the other 2 servers). You could look into SQLite replication solutions, some are mentioned here: https://sqlite.org/forum/info/4fc617ecaf47d544ea8baae0930553a3a52e63067d3adfff9ce1a217cc470aba

[thielj]

Hi Jakob. You may want to have a look at one of these:

https://github.com/benbjohnson/litestream -
https://github.com/rqlite/rqlite

[nitnelave]

Each LLDAP instance is stateless. Assuming they all have the same config, sharing a postgres or MySQL DB should work well (and afaik many users do this, as a HA setup).

Make sure to use a key_seed, not a key_file for the private key.

Sharing SQLite is not recommended (each file should only be opened by a single process).

[thielj]

HI. I think SQLite is safe to be used by multiple processes.

https://www.sqlite.org/faq.html#q5