Hydra geo-redundant failover for Postgresql
Engineering Manager at Groupon for relational databases, leading efforts for development of solutions and integrations between all the Groupon infrastructure ecosystem, principally focused on the database aspect. With more than 15 years of experience in development and database administration, Jose is really interested in automation, and improvement of processes.
Á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.
- 50 min
- PostgresConf US 2018
- Operations and Administration