rqlite creator here. rqlite is not simply a SQLite replication technology[1], so probably won't meet your needs. Maybe litestream.

[1] https://rqlite.io/docs/faq/#can-i-use-rqlite-to-replicate-my...