Get the latest tech news
PostgreSQL High Availability Solutions – Part 1: Jepsen Test and Patroni
02 Dec 2024, tagged database jepsen test distributed system consistency HA Note: code used in this article can be found on the Github repo jepsen-postgres-ha. I’ve used Cockroach DB for a few my side projects.
Second, I want to see it happens in real world: the Patroni auto failover makes manually triggering this problem hard because there is only a short time for the commit to be replicated. Second, the nemesis package I copied from the original test is not very suitable to reproduce this issue: it randomly introduce different failures (passed in by cli flags) by a predefined average interval. Which makes it harder to trigger the exact scenario (the transaction network round trip time will be different depends on the number of ops so 120ms is less likely to close connection after commit).
Or read this on Hacker News