Answer the question
In order to leave comments, you need to log in
SQLite3 replication (master-slave)
Good afternoon everyone.
So, there is a need to keep a second copy of a rather large SQLite database up to date (a copy on another piece of hardware on another continent).
Possible solutions
1. Copy the database as an rdif or completely - a lot of traffic and a rather unstable solution.
2. sqlite3-rdiff (http://sqlite.mobigroup.ru/home) there was an embarrassment, I naturally could not extract the source codes of this tool from the hard currency fossil.
3. Implement a query log and execute it every N minutes. The solution seems to be the most stable, but there is a possibility that someone has already “piloted” it for me and everything was invented before us.
If someone knows a ready-made solution, I will be grateful for the comments!
Thanks in advance!
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question