trying to figure out

[denis-marecky]

Trying to understand, how it's best way to solve my task
I have vps server 1, where sqlite.db is updated, making some internet requests to update database
Also I have another servers, that need to get updates from server 1, like every 6 hours for example (I don't want to load other servers all the time, so need updates every x hours). Those databases read-only

Created config file, that works somehow:

• path: /root/sqlite.db
  replicas:
  • url: sftp://root@my-ip-here:port-here/root/replica.db
    key-path: /root/litestream-p

It's created some folder replica.db(not file) with WAL stuff. So I need installed litestream on another servers, to get my database updated? How litestream must be configured? Is it possible to replicate full database, not wal logs? Is it possible to update it from nodejs app, to not reload database(it's ead-only)?

[namelessjon]

Hi @denis-marecky

I think to solve this you'd end up running litestream on all of the servers.

On the server 1, where the db gets updated, you'd run litestream replicate to get a replica written continuously to the replica (in your config file that's sftp://root@my-ip-here:port-here/root/replica.db). Meanwhile on the other servers you'd periodically run litestream restore to get an up to date copy of the database. Given you can't update a replica in place by litestream, you'd then need to swap the newly restored sqlite3 database with the one nodejs was using, probably via mv new-replica.db node.db or so. If your node app reopens the db on every request (a perfectly acceptable sqlite access model), you'd then more or less seemlessly get new data.