Method to replicate sqlite database across multiple servers

sqlite replication distributed-computing high-availability rethinkdb
ManuParra picture ManuParra · Apr 16, 2013 · Viewed 33.3k times · Source

I'm developing an application that works distributed, and I have a SQLite database that must be shared between distributed servers. If I'm in serverA, and change sqlite row, this change must be in the other servers instantly, but if a server were offline and then it came online, it must update all info equal other servers.

I'm trying to develop a HA service with small SQLite databases.

I'm thinking on something like MongoDB or ReThinkDB, due to replication works fine and I have got data independently server online I had.

There are a library or other SQL methodology to share data between servers?

Thanks in advance.

Answer

Philip O'Toole picture Philip O'Toole · Sep 3, 2014

I used the Raft consensus protocol to replicate my SQLite database. You can find the system here:

https://github.com/rqlite/rqlite

Related questions

Does SQLite support replication?

In an application which embeds SQLite3 and uses an in-memory database, is it possible to replicate the database between two running instances of the application? I could do this by hand with a homebrew protocol duplicating all my DB accesses, …

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More