winsletts

5 ms·

1. 1.▲
   by winsletts 11y ago

   Take a look at the code we have open sourced: https://github.com/compose/governor
2. 2.▲
   by winsletts 11y ago

   Bucardo with multi-master is fantastic when a DBA can configure the multi-master and manage future changes. Bucardo requires each table to have proper Bucardo configuration and each table on each host to have the proper schema, since Bucar
3. 3.▲
   by winsletts 11y ago

   We tested with PGPool and PgBouncer in various iterations. PGPool failed at basic failover. It worked fine while the leader remained leader. It would failover to the follower who became leader, but after the first failover, it would stall
4. 4.▲
   by winsletts 11y ago

   The problem with etcd members on every Postgres node is that clusters fixed nodes or members. etcd doesn't function well in an environment where you could tear down / build up new nodes. Most of our Postgres service runs on AWS,
5. 5.▲
   by winsletts 11y ago

   The code relies on functionality in etcd to prevent a race condition. Using `prevExist=false` on acquiring the leader key, the set will fail if another node wins the race. The functionality in the code is here: https://github.co
6. 6.▲
   by winsletts 11y ago

   I imagine this is one of those situations where the truth will never be available. All participates have taken sides, and have skewed / omitted / shaped their own stories for their own interests. I wish we had a black box recorde