Tutorial on Modern PostgreSQL High Availability
Álvaro is a passionate database and software developer. Founder of OnGres, he has been dedicated to PostgreSQL and R&D in databases for more than two decades.
Álvaro is at heart an open source advocate and developer. He has created software like StackGres, a Platform for running Postgres on Kubernetes. As a well-known member of the PostgreSQL Community, Álvaro founded the non-profit Fundación PostgreSQL and the Spanish PostgreSQL User Group. He has contributed, among others, the SCRAM authentication library to the Postgres JDBC driver.
You can find him frequently speaking at PostgreSQL, database, cloud (becoming an AWS Data Hero in 2019), and Java conferences. In the last 10 years, Álvaro has completed more than 100 tech talks (https://aht.es).
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)