Now, HandyRep is still somewhat of a work in progress (consider it a version 0.8), but I'll be talking about it Tuesday at SFPUG. We'll have live video of the presentation and demo, starting at around 7:15pm PST.
The goals of the HandyRep project are:
- Supports configurable automated failover logic for high availability
- Supports manual failover, replication monitoring, node provisioning, and remastering (with 9.3).
- Written entirely in Python, for easy hackability
- All functionality is accessible as an embeddable Python library.
- All functionality accessible via a REST interface when using the included Flask application with a web server.
- Supports user-supplied plugins to let it interface with applications in your environment.
- Can be run from a 3rd-party server (such as a pgbouncer server)
- Designed to minimize the per-node installation/configuration requirements. No "agent" is installed on the nodes.
- Highly configurable to support whatever the user's PostgreSQL configuration and file arrangement is on each node.
- Supports multiple replicas and remastering (requires 9.3)
- Integrates 3rd-party connection failover, such as pgbouncer, HAProxy, or BigIP.
- Integrates with configuration management utilities, such as Puppet, Chef, CFEngine and SaltStack.
- Integrates with archiving utilities such as WAL-E and Barman
- Licensed under the same terms as PostgreSQL itself.