benbjohnson / litestream

Streaming replication for SQLite.
https://litestream.io
Apache License 2.0
11.02k stars 252 forks source link

Feature request: Reverse replication #552

Open code959437957 opened 10 months ago

code959437957 commented 10 months ago

We have three Node:

  1. The main prod node: hosting the product online database;
  2. The backup server: provide SFTP backup for litestream to replicate and backup on to it
  3. The testing node: we often check the backup is ok?

The feature request is for the testing node:

we need to replicate data continue from backup server into testing node. we write script to compare hourly to check if the backup data is ok.

and we also using testing node to run tests with data

code959437957 commented 10 months ago
shapes at 23-12-28 06 43 42

And this also can be use to replicate database to slave db server instance.

rishi-kulkarni commented 10 months ago

+1 This would be useful for data warehousing without having to redownload the entire DB every time.