Geo-Distributed Postgres Replication Using Debezium
summary
Shows how to use Debezium and Kafka to replicate PostgreSQL data between geographically distributed database nodes, and how to automate failover and minimize downtime by switching between those Postgres instances.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:09Solution requirements
- 4:20System architecture
- 6:29Solution components
- 11:43Debezium setup
- 13:09Writing sink connector
- 15:56Management console
- 17:19Failover algorithm
- 20:06Emergency failover
- 23:16Application adaptation
- 25:46Data initialization and sync
- 27:52Operation and monitoring
- 31:02Implementation results
- 33:54Q&A
related talks
39mReliable Data Replication from Postgres on Kubernetes
42mWhy PostgreSQL people should care about Kafka and Debezium?
33mTransitioning from Debezium ElasticSearch to Postgres for Streamlined Resilience
27mBuilding Event-Driven Systems with PostgreSQL Logical Replication and Drasi
26mDebezium Server - New CDC runtime on the horizon!
19mChange data capture with Debezium…and without
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
55mHigh Availability with PostgreSQL and Pacemaker