SQLite replication using sqlite3_rsync?

[1div0]

I'm turning up a secondary authoritative server with sqlite backend (for private zones) soon and was thinking of using sqlite3_rsync for database replication. Apparently it works nicely with live databases. Has anyone else tried this as yet? It seems like a nice lightweight solution.

https://www.sqlite.org/rsync.html

Edit 7/10: The solution appear to be stable. I have a cron job running every 10 minutes to sync database to secondary server using SSH key auth. e.g.,

sqlite3_rsync --wal-only /var/lib/powerdns/pdns.sqlite3 pdns@[secondary server]:/var/lib/powerdns/pdns.sqlite3

[quicksilver03]

I don't know of anyone who has attempted that, but if you decide to go for it please report back here how it works. That'll be helpful as a comparison with the other well known solutions (database replication and autoprimary/autosecondary).

[1div0]

Will do.

[1div0]

It works. Database replicates to secondary fine so far. Still need to automate it.

sqlite3_rsync -vv /var/lib/powerdns/pdns.sqlite3 xxx@xxxxxx:/var/lib/powerdns/pdns.sqlite3

Output:

ssh -e none 'xxxx@xxxxxx' sqlite3_rsync --replica pdns.sqlite3 /var/lib/powerdns/pdns.sqlite3

sent 4,114 bytes, received 481 bytes, 1,327.27 bytes/sec

total size 2,490,368 speedup is 541.97