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.
During the latest 10 years, Emanuel has been specialized in Open Source Databases widely varied and worked in companies like PalominoDB, 2ndQuadrant, Pythian & Percona. Now, he is involved as a Senior Database Consultant at OnGres specialized in support, database administration and deployment.
He also worked in autonomous projects on different companies, mostly related with Database Architecture and Planning, benchmarks and consultancy. Most managed systems were in MySQL, PostgreSQL, Redshift, ClickHouse, MongoDB and derivates. Passionate [and still newbie] about hydroponics and IOT.
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: 23/35)