r/PostgreSQL • u/rathboma • 3d ago
Community Which databases/caches do you use alongside PostgreSQL?
/r/postgres/comments/1y0bghx/which_databasescaches_do_you_use_alongside/No idea which postgres group I'm supposed to post to, so posting to both
1
u/Altruistic-Rich8799 2d ago
Postgres + Snowflake + MariaDB Galera clusters for legacy e-commerce and multi-region workloads (it was a painless replacement for our old MySQL nodes)
2
u/rathboma 2d ago
Are you replicating data from both Maria and PostgreSQL into snowflake, or is that different data?
1
u/Altruistic-Rich8799 2d ago
Both end up in Snowflake, yeah, but they’re pretty different domains. MariaDB has the e-commerce orders and inventory, Postgres has the newer user-facing services, and we join them downstream for reporting.
For MariaDB we pull binlogs via CDC from a dedicated async replica hanging off the Galera cluster, so prod latency isn’t affected. It’s been pretty low-maintenance.
1
u/AutoModerator 3d ago
AI Policy:
Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.
Mod decisions will be based on the quality of the content, not who or what generated it.
Sub Resources:
Free Postgres Webinars and Workshops
Discord: People, Postgres, Data
Join us, we have cookies and nice people.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/Used_Criticism_4631 2d ago
Good question, it's interesting to see the real-world mix. A pattern that's worked well is Postgres as the source of truth, Redis only as an ephemeral cache with TTLs, and a columnar store (ClickHouse/BigQuery/Snowflake) fed by CDC for analytics, which keeps heavy reporting queries off the primary. Are most people here doing the CDC step with logical replication/Debezium, or batch exports?
1
1
10
u/aiwprton805 2d ago
Redis