News for hackers. Stuff that matters.

A comment on Run PostgreSQL. The Kubernetes Way. Parent comment

Re:Run PostgreSQL. The Kubernetes Way by gbartolini on Saturday September 23, 2023 @08:08AM (#37622543)
Why not dedicate some worker nodes using taints/tolerations/labels, even on bare metal, with locally attached storage? I wrote this many years ago now but that's the reason why we started CloudNativePG (OpenEBS might not be the answer today, but there are many storage engines now, including topolvm which brings LVM to the game): https://www.2ndquadrant.com/en/blog/local-persistent-volumes...

It is ultimately your choice. I am a big fan of shared nothing architecture for the database. (I am a maintainer of CloudNativePG)

[ Parent | on HN ]
Re:Run PostgreSQL. The Kubernetes Way by sebasmannem on Sunday September 24, 2023 @11:22AM (#37633930)
Yeah, and let Postgres take care of redundancy. I agree that this is an interesting proposition. AFAIK PortWorkx could do a similar thing, but then with storage redundancy. Basically: - storage is synced to 3 local storage devices spread across 3 different k8s nodes. This could be NVMe. - pod is only scheduled next to one of the three - reads are local, writes are local (for fsync) and synchronised to the other devices. I would love to test with pg_tps_optimizer against Portworkx
[ Parent | on HN ]