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.