The Inner Workings of Distributed Databases
When is the right time to "level up" from "I'm good with just plain old Postgres" to QuestDB, InfluxDB, Patroni, etc.?<p>> Unfortunately, automatic failover is solved neither by PostgreSQL nor TimescaleDB, but there are 3rd-party solutions like Patroni that add support for that functionality. PostgreSQL describes the process of failover as STONITH (Shoot The Other Node In The Head), meaning that the primary node has to be shot down once it starts to misbehave.<p>Does QuestDB do "Raft consensus"? I don't see Raft mentioned in the article.<p>Aren't all distributed databases basically really clever wrappers around write-ahead log + really tight timestamp/clock syncing?