manatee

This is inferior to the Manatee design: https://github.com/joyent/manatee Funnily enough I ran into this yesterday when Mist was posted and I looked at what other projects were under the umbrella.

Sure, but the underlying primitives are better. Specifically it supports quite flexible binary replication including the new logical replication features. With this you can build things like Manatee[1] which enable effectively seamless HA. The platform I am currently working on Flynn[2] uses a variant of this state machine to implement an effectively maintenance free Postgres cluster. In future though there will be support for bi-directional replication in Postgres, i.e true multi-master support. [1] https://github.com/joyent/manatee [2] https://flynn.io/

Thanks for writing this up! At Joyent, we built a similar system for automated postgresql failover called Manatee. I'm sure today we would have used a Raft-based system, but that was not available when we did this work, so we used ZooKeeper. We haven't spent much time polishing Manatee for general consumption, but there's a write-up on how it maintains consistency[1]. The actual component is available here[2], and it's also been ported to Go as part of Flynn[3]. Edit: Manatee uses synchronous replication, not async, so it does not lose data on failover. [1] https://github.com/joyent/manatee-state-machine [2] https://github.com/joyent/manatee [3] https://github.com/flynn/flynn

It sounds like if you smash together Project Goverenor and Flocker you get Joyent's Manatee[1]. It uses ZooKeeper to automatically manage a PostgreSQL cluster. It also uses a separate ZFS dataset to hold the database, so backup and restore can be accomplished just using "zfs send" and "zfs recv". It's open source[2] Javascript if you want to check it out. [1]: https://docs.joyent.com/sdc7/troubleshooting-sdc7/manatee [2]: https://github.com/joyent/manatee