CDC on AWS with PostgreSQL, Debezium, Kafka and ClickHouse
Intro Your analytics team wants fresh numbers, and your PostgreSQL database is not built for them. You can run heavy queries on production and slow down the app. Or you can copy the data once a night and work with yesterday’s numbers. Or maybe you want to squeeze the data in real time (incrementaly) from production system and in parallel build new one. Let’s say if client reached all the limits of vertical scaling. ...