search

maxpert / marmot

A distributed SQLite replicator built on top of NATS
https://maxpert.github.io/marmot/
MIT License
1.81k stars 41 forks source link

HA setup with Master and slave #109

Open kannanvr opened 5 months ago

kannanvr commented 5 months ago

Hi All, Is it possible to have the HA setup with Master and slave only for marmot? If yes, Do you have any conf file to configure it. I have tried configure it. But I am unable to setup master and slave setup

Thanks, Kannan V

gedw99 commented 4 months ago

Its possible but requires some code changes.

Why dont you want multi master ?

kannanvr commented 4 months ago

@gedw99 , Thanks for your reply. 2 master is possible also fine. Is it possible to configure 2 master configuration? How can it be done

gedw99 commented 4 months ago

Multi master is afaik how it automatically works mate .

gedw99 commented 4 months ago

@kannanvr

https://github.com/superfly/corrosion is another option.

It's SQLITE with multi master using Peer to peer, and does not need NATS at all and have a simple HTTP API. Under the hood it uses CRDT to do the data sync, as oppose to RAFT which NATS uses.

The only downside is that the SQL cant do joins as outlined here: https://github.com/superfly/corrosion/issues/209

kannanvr commented 4 months ago

Thanks for the suggestions.i will try sqltite

gedw99 commented 4 months ago

Happy to chat on telegram about how I use it . See my profile:)