Method to replicate sqlite database across multiple servers
distributed-computing, high-availability, replication, rethinkdb, sqlite
Solution
I used the Raft consensus protocol to replicate my SQLite database. You can find the system here:
https://github.com/rqlite/rqlite
Problem
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?