L
L
la02013-06-27 15:16:42
SQL
la0, 2013-06-27 15:16:42

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

1 answer(s)
G
gleb_kudr, 2013-06-29
@gleb_kudr

www.sqlite.org/backup.html here are the docs on SQLite methods for replication. The very best solution.
Well, or at the file system level.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question