We present a high-availability replication system for embedded databases (SQLite-class deployment model) implementing warm standby architecture with WAL streaming, automatic failover, quorum-based split-brain prevention using fencing tokens and epoch-based leadership, multi-phase controlled switchover coordination, and logical replication for selective table sync. The split-brain module uses observer (witness) nodes for quorum: a 3-node cluster (1 primary + 2 standby) requires quorum of2; a 2-node + 1-observer configuration also achieves quorum of 2. Fencing tokens ensure that write operations from a stale primary are rejected by standbys that have accepted a higher epoch. While WAL-based replication is standard in server databases (PostgreSQL, MySQL), no embedded database (SQLite, DuckDB, LevelDB, RocksDB) provides built-in replication with split-brain detection, fencing tokens, role management, and controlled switchover.
Daniel Moya Vaca (Fri,) studied this question.