Marmot v2: A Distributed SQLite Replication System with MySQL Wire Compatibility
By
zX41ZdbW
Kettled twice. Extra chewy, extra trustworthy.
Summary
Marmot v2 is a leaderless, distributed SQLite replication system that uses a gossip-based protocol with distributed transactions and eventual consistency. It provides a MySQL wire-compatible interface, making it easier to deploy than traditional MySQL active-active replication setups. The system is designed for read-heavy edge scenarios where traditional database replication is too complex, addressing issues like manual failover intervention, split-brain scenarios, and scalability challenges in edge deployments.
Key quotes
· 4 pulledMarmot v2 is a leaderless, distributed SQLite replication system built on a gossip-based protocol with distributed transactions and eventual consistency.
MySQL active-active requires careful setup of replication, conflict avoidance, and monitoring. Failover needs manual intervention. Split-brain scenarios demand operational expertise.
Marmot excels at read-heavy edge scenarios.
The Problem with Traditional Replication: This complexity doesn't scale to edge deployments.
You might also wanna read
Postgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d agoPostgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d ago
Comparing Transaction Isolation Levels in MySQL and MariaDB Through Automated Hermitage Testing
This article discusses transaction isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) in MySQL and MariaDB,
theconsensus.dev·24d ago
Columnar Storage as Database Normalization: Understanding the Relational Foundation
The article explains that columnar storage in databases is essentially a form of normalization within the relational model, not a completely
buttondown.com·1mo ago
PgQue: Zero-Bloat Postgres Queue System Using Pure SQL and pg_cron
PgQue is a zero-bloat Postgres queue system that revives the PgQ architecture originally designed at Skype for handling messaging for hundre
github.com·1mo ago
Rethinking Database Usage: When File-Based Storage Might Be Better Than Traditional Databases
The article challenges conventional wisdom about database usage, arguing that databases are essentially just files on disk and that for many
dbpro.app·1mo ago