piraeus-operator VS kubegres

https://piraeus.io/ might be a good option rather than longhorn, check it out.

Linstor using https://piraeus.io/

For kubernetes I also tried https://piraeus.io/ which is a drbd-operator for kubernetes; it creates+mirrors LVM volumes between nodes. In my experience it was faster than ceph although not 100% stable; sometimes a volume would get stuck on a node and only a reboot could help.

Take a look at https://github.com/piraeusdatastore/piraeus-operator

A lot better.

A couple of years ago I could see volumes on Linstor getting completely stuck and unrecoverable whenever the network was getting busy or unstable. Nodes reboot were a nightmare too.

Have a setup now with their Piraeus operator[1], Kubernetes >= 1.20, rancher and calico, and it seems to be very stable. XFS have been giving better results too. Still, better not to try too many reboot loops on the nodes.

1: https://github.com/piraeusdatastore/piraeus-operator/

A good comparison with other operators here [2022]: https://blog.palark.com/cloudnativepg-and-other-kubernetes-o...

Personally I've only used Kubegres (https://www.kubegres.io/), which didn't even make the above list. It's ok for a personal project.

All k8s solutions for postgres take subtly different approaches. It seems that they've all converged on the Operator pattern. The basics are easy: run a database process which persists data to a cloud disk of your choice. The hard parts are how to update, migrate, backup, restore, monitor, failover, replicate, etc. These kubernetes "operators" promise to fulfill the role of a DBA but, just like hiring a DBA, it requires buy-in to their approach.

Reactive-Tech / Kubegres (opérateur)

I like https://www.kubegres.io, it takes a little getting used to how it works. I probably wouldn't use it for a huge database, but for things under a few TB it works great.

I don't know if you're using Kubernetes, but Kubegres is great for self hosting postgres on a cluster.

Any experience with https://www.kubegres.io/ ?

How does this compare with something like kubegres?

https://www.kubegres.io/

https://www.kubegres.io/ has worked well for me. You can use custom images, provided they follow the conventions of the official postgres image. I haven't tried a major-version upgrade yet - my impression is that it will probably be a bit painful and involve some downtime and manual ops.

Some of the more advanced operators might better handle the upgrade problem? But in general, I've been happy with Kubegres for a ~10GB database with low traffic.

There are some great operators out there that make deployment and management easy. I use kubegres managed with pgadmin and it has been working well for me.

reactive-tech/kubegres (operator)