Re:Protecting reserved roles with PostgreSQL Hooks
by nextaccountic on Saturday July 03, 2021 @03:46AM
(#27720032)
How many dedicated servers do you have? Do you manage the servers themselves or use a cloud offering like Hetzer?
Re:Protecting reserved roles with PostgreSQL Hooks
by jjeaff on Tuesday July 06, 2021 @10:33PM
(#27756759)
I use a single dedicated server that I rent from a hosting provider like Hetzner.
If I needed to use multiple servers it would admittedly get a bit more complicated. But only if i needed to replicate persistent data like the database.
I then decided to go back to running my own database but this time in a docker container on k3s on bare metal. A few hours fiddling with the config upon launch and that's it. Rock solid, way more performant because I can tweak the config to my specific needs.
In the 2 years I have been running a MySQL server on k3s, I have about 60-90 seconds of down time. Caused by 3 separate instances where the db became unresponsive and k3s rebooted it. Most likely just some tweaks i need to make with the health check timeouts.
It has been more set it and forget than a managed solution and about 20% the cost.