litesync Questions

keving

Hi.

I recently came across litesync and would appreciate it if you could answer some questions on its potential suitability for storage of data in a high availability / load balanced scenario.

Can litesync by setup in a multi-master type scenario.
eg: Multiple computers (nodes) that have their own local database which then replicates all changes to all other nodes.
I assume that the replication is performed as a background process meaning that data could be lost if a node crashed before its data was replicated. If the nodes are online and connected to each other on a local network how quickly is data replicated to other nodes?
Are there any events to indicate that the replication process has changed data in the local database or would we have to poll the table(s) for changes?

Thanks.
Kev.

Bernardo

Hi Keving!

Yes, LiteSync supports multi-master replication but for now only on a star topology. It means we need to choose a device that will centralize the connections from other nodes.

The data is replicated as soon as the transaction is committed (if the node is on-line), in a few milliseconds.

I am working on an event hook that will be fired whenever a database update occurs. Notice that using the SQLite pre_update_hook will not work.

Best regards,