HN

Comments (24)

• _a9
  I used this a while back while running a waybackmachine style site for a large social media platform. I wanted to keep it simple with sqlite but when it got popular it started to become a problem. Marmot was the only thing that I was able to get to work with the amount of data I was pulling in. It would sync the master db from the main archiver server to all the ha servers so the user would be able to access it immediately no matter what ha server they got. The dev team was nice to talk to when I had some issues in setting it up.It was definitively a weird backend setup I had made but it just worked once set up so I didnt have to touch any of the frontend code.
• Menu

  maxpert
  Author here! Every time I post my own stuff here it seems to sink, so hopefully this actually reaches some of you.Marmot started as a sidecar project using triggers and polling to replicate changes over NATS. It worked, but I hit a wall pretty fast. Most people really want full ACID compliance and DDL replication across the cluster. I realized the only clean way to do that was to expose SQLite over a standard protocol.While projects like rqlite use REST and others go the page-capture route, I decided to implement the MySQL protocol instead. It just makes the most sense for compatibility.I’ve reached a point where it works with WordPress, which theoretically covers a huge chunk of the web. There are scripts in the repo to deploy a WP cluster running on top of Marmot. Any DB change replicates across the whole cluster, so you can finally scale WordPress out properly.On the performance side, I’m seeing about 6K-7K inserts per second on my local machine with a 3-node quorum. It supports unix-sockets, and you can even have your processes read the SQLite DB file directly while routing writes through the MySQL interface. This gives you a lot of flexibility for read-heavy apps.I know the "AI slop" label gets thrown around a lot lately, but I’ve been running this in production consistently. It’s taken a massive amount of manual hours to get the behavior exactly where it needs to be.
• Menu

  geenat
  Oh man, tons of updates including DDL replication! V2 looks very impressive.Now I'm curious how sharding/routing is handled- which seems like the final piece of the puzzle for scaling writes.
• joelthelion
  Naïve question : why would you want to use this over, say postgre?
• Menu

  savolai
  So would it make sense to use to use this on a nas to keep wordpress sites’ content backed up?
• Menu

  ChocolateGod
  I wonder if you could tie this with Litestream to get streamed backups.
• schulm
  Is this suitable for LocalFirst apps?
• wg0
  Is there something similar that exists for Postgres?
• iliesaya
  is this an alternative to SymmetricDS to replicate database on multiple node without master/slave ?
• Menu

  PunchyHamster
  weird choice considering SQLite is more similar to PostgreSQL
• Menu

  bawolff
  > Marmot uses gossip protocol (no leader)So umm, does that mean it sacrifices consistency?
• oblio
  Funny, I was just reading about this:https://github.com/synopse/mORMot2FreePascal ORM, so in an adjacent space (ORM, can work with both SQLite and MySQL).I guess DB devs really love marmots? :-))
• naveed125
  That looks pretty cool
• phplovesong
  Looks like yet another AI generated project.