Hydra geo-redundant failover for Postgresql
Engineering Manager at Groupon,developing solutions, creating tools and processes for relational databases.
Álvaro is a passionate database and software developer. He has been an almost exclusive user of PostgreSQL, as THE database, for more than 15 years. Founder of OnGres, he is dedicated to R&D in databases. Álvaro founded ToroDB, previously the “Billion Tables Project” and keeps working on innovative open source solutions for databases, specially PostgreSQL. On his free time he also contributes to open source and PostgreSQL, like SCRAM's support in PostgreSQL's JDBC driver.
He is a frequent speaker at PostgreSQL, database and Java conferences. Álvaro created the Spanish PostgreSQL user group, one of the largest in the world, with 750+ members.
No video of the event yet, sorry!
PostgreSQL High Availability (HA) is a very desirable goal for most, if not a strict requirement. And there are technologies and literature to help provide HA on a PostgreSQL cluster.
However at Groupon we manage hundreds of database servers, distributed across several datacenters in the world. And our internal policy mandates that we need a Disaster Recovery mechanism to switch a complete datacenter over to another.
With this main requirement we have built Hydra, a soon-to-be-open-sourced solution that implements geo-redundant failover. It relies on Consul for distributed consistency and as the basis for the multi-datacenter approach, and is implemented as a lightweight agent in Java8.
- 2018 April 19 08:50
- 50 min
- Liberty I
- PostgresConf US 2018
- Operations and Administration