marmot

A distributed SQLite server with MySQL wire compatible interface

What is marmot?

A distributed SQLite server with MySQL wire compatible interface

Overview of marmot

What it is

Marmot v2 is a leaderless, distributed SQLite replication system built on a gossip-based protocol with distributed transactions and eventual consistency. It provides a MySQL wire compatible interface, allowing any MySQL client to connect.

Key features

  • Leaderless architecture: no single point of failure; any node can accept writes.
  • MySQL protocol compatible: connect with any MySQL client (DBeaver, MySQL Workbench, mysql CLI).
  • WordPress compatible: full MySQL function support for running distributed WordPress.
  • Distributed transactions: Percolator-style write intents with conflict detection.
  • Multi-database support: create and manage multiple databases per cluster.
  • DDL replication: distributed schema changes with automatic idempotency and cluster-wide locking.
  • Built-in vector search: local IVF/PQ vector indexes for RAG workloads, with live CRUD and exact rerank from the base table.

Use cases

Marmot is designed for read-heavy edge scenarios:

  • Distributed WordPress: multi-region WordPress with replicated database.
  • Lambda/Edge sidecars: lightweight regional SQLite replicas with local reads.
  • Edge vector databases: built-in ANN search plus distributed embeddings with local query.
  • Regional config servers: fast local config reads with replicated writes.
  • Product catalogs: geo-distributed catalog data with eventual sync.

Getting started

bash # Start a single-node cluster ./marmot-v2 # Or run as daemon (background) ./marmot-v2 -daemon -pid-file=/tmp/marmot/marmot.pid # Connect with MySQL client mysql -h localhost -P 3306 -u root # For a 3-node WordPress cluster: cd examples/wordpress-cluster ./run.sh up See the repository README for more detailed instructions.

License and pricing

This project is licensed under the MIT License. It is open source and free to use.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/maxpertmarmot.svg)](https://yunodb.com/tools/maxpertmarmot?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/maxpertmarmot?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/maxpertmarmot.svg" alt="Featured on YunoDB" height="20"></a>