Tutorial on Modern PostgreSQL High Availability
Álvaro is a passionate database and software developer. Founder and CEO of OnGres, an “ON postGRES” startup. Álvaro has been dedicated to PostgreSQL and R&D in databases since two decades ago.
You can find him frequently speaking at PostgreSQL, database, cloud, and Java conferences. Every year, Álvaro travels approximately three-four times around the globe—in 2020, he will hit the milestone of having delivered 100 tech talks.
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 EDT
- 3 h
- Liberty I
- PostgresConf US 2018
- Operations and Administration
- Requires Registration:
- Yes (Registered: 35/35)