Tutorial on Modern PostgreSQL High Availability
Á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.
Pablo is a software developer focused on databases. Having worked with PostgreSQL for the last 4 years, now he is a database engineer at OnGres. He also manages the Java development team, and he contributes with the support team.
He is also a frequent speaker in development events in Spain, and has spoken in the last PGConf Europe
No video of the event yet, sorry!
It’s 3am. Your phone rings. PostgreSQL is down, you need to promote a replica to master. Why the h**l isn’t this automatic?
If you thought of this before, you want automatic High Availability (HA). Don’t miss this tutorial! We will enter the world of Modern PostgreSQL HA.
Good news, there are several new, “modern” solutions for PostgreSQL HA. However, there are several solutions and it's not easy to pick one. Most require non-trivial setups, and there are many small caveats about HA like how to provide entry points to the application, HA correctness, HA vs. read scaling, external dependencies, interaction with cloud environments, and so forth.
This tutorial will:
- Explore some of the "modern" PostgreSQL HA tools.
- Analyze the caveats and important facts to know when deploying an HA solution.
- Work step-by-step to build a fully automated HA solution on the AWS cloud.
Source code included! BYOL -- Bring Your Own Laptop! Most of the content is practical, you will be working on it.
- 2018 April 16 09:00
- 3 h
- Liberty I
- PostgresConf US 2018
- Operations and Administration
- Requires Registration:
- Yes (Registered: 35/35)