8 ms·
A subtle advantage of cnpg is that it doesn't use statefulsets, instead the operator handles things like mapping storage volumes and stable identities. Regular
by turtles3 3y ago
A subtle advantage of cnpg is that it doesn't use statefulsets, instead the operator handles things like mapping storage volumes and stable identities. Regular kubernetes statefulsets have some tricky sharp edges for failure recovery.
I don't know if all of these alternatives use statefulsets but I remember several doing so.
I've personally found cnpg to be pretty robust, and supports everything you will eventually need once you're locked into a solution (eg. Robust backups, CDC, replica clusters).
I'm yet to find anything of a similar standard for mysql.
EDIT: it should also be noted that CrunchyData is a proprietary solution and requires a license to use in production. This is not particularly obvious from their docs.
- activescott 3y agoWhat sharp edges are you referring to with statefulsets?
- turtles3 3y agoCnpg's docs articulate this better than I could: https://cloudnative-pg.io/documentation/1.16/controller/ https://cloudnative-pg.io/documentation/1.16/controller/ Statefulsets have their place but are surprisingly inconvenient for database workloads.