Postgres, Databases and integration laboratories
HA, CDC and other laboratories for Postgres
- 1 min read
Series: Postgres
Description
This repository contains several laboratories around Postgres implementations for lecture and training purposes.
Some of them are focused on High Availability, others are focused on Change Data Capture (CDC), but not limited to.
- Patroni HA with callbacks
- Doing failovers with callbacks against PgBouncer, for managing connection.
- Callbacks are used for Pausing, updating databases, and resuming connections.
- Logical Replication through different Postgres Versions
- This laboratory shows how to use Logical Replication with slight changes in the DDL.
- The approach can be used for Major Upgrades, eg.
- The pgbench implementation allows to test the failover and monitor connection states.
- Sharding with PGCat
- Implementation of a Hash-Sharding based using PgCat. Potentially reusable with PgDog.
- Patroni on Swarm
- Implementing a Patroni cluster over Docker Swarm in AWS EC2 machines.
- Several solutions are present in this laboratory: Timescale HA, and Patroni/Citus, among others.
- Currently WIP.
Other laboratories contain Transactional Outbox strategies, Debezium and Airflow integrations, which would be used in future posts.