autobase.tech - Automated database platform for PostgreSQL®

[nelsonic]

Following the Fly.io Postgres fiasco dwyl/auth#325 (comment) we are back to the drawing board when it comes to Postgres. 🔍 💭

We took a look at Managed Postgres on DigitalOcean dwyl/learn-devops#90
and for a simple app that doesn't have many records/updates it would be fine but the moment you need
to scale to a decent size and speed, the costs get out-of-hand compared to self-managing ... dwyl/learn-devops#90 (comment)

Sooooo ... this is what I'm considering: run https://postgresql-cluster.org on Hetzner dwyl/learn-devops#97

Using 3 VMs in 3 data centres; eu-central (fsn1), us-west (hil) and ap-southeast (sin): dwyl/learn-devops#97 (comment)

[asntc]

We had a brief hiccup where we couldn't make progress ... 🧱
Opened an issue: vitabaks/autobase#811 and got a reply super quick! 🏎️
This gives us confidence that the project is maintained and we are making a good choice to use it. 🤞

[nelsonic]

Rebranded to "autobase" ... https://github.com/vitabaks/autobase 💭

[asntc]

https://postgresql-cluster.org/ (before the rebrand)

full:

annoyingly it has scroll-based rendering so some of it is missing. 🤦

anyway, this is what it looked like when we first considered using it.

[nelsonic]

Managed to deploy the cluster this morning and do a full doc & screen recording! 📝 📺

#insomnia FTW! 😪 🎉

Just have to edit down ~T2h of screen recording down to T7m and we can ship both!!
GOTO: dwyl/video#95

[nelsonic]

Currently trying to connect to the Postgres cluster on Hetzner but hitting a brick wall 🧱 🤦‍♂️
Opened issue requesting help: vitabaks/autobase#824

[nelsonic]

@MikeRund never be afraid of asking a NOOB Question. Having a Beginner's Mind is a Super Power! 🔰

[MikeRund]

This is a great use-case of not not being afraid to ask the questions, thanks @nelsonic and congrats on deployment! 🚀

[nelsonic]

As noted in vitabaks/autobase#824 (comment) this is all working now.
Most importantly, I understand how the deployment works end-to-end. 👌
So ... I'm going to DELETE it all again and re-deploy from a clean slate. 0️⃣

[nelsonic]

First PR: vitabaks/autobase#835

[nelsonic]

My PR was merged with the cheaper server types which makes Hetzner significantly more cost-effective! 👌
Re-re-recorded the screencast using the cheaper servers. 💻 ⏺️ ✅

It's not perfect. But I just want to ship this now!! ⏳
Editing. 🧑‍💻

[nelsonic]

it's not an "update" though ...

it's a whole new app that replaces the old!
And for whatever reason is downloading incredibly slowly even on our 1Gbps connection!

I'm already editing while it downloads in the bg. ⏳

[ndrean]

@nelsonic do you use Ansible to setup your (VPS?) Hetzner ? Do you use containers?

[nelsonic]

@ndrean yeah, autobase uses ansible & containers under the hood.
But my reading is that it’s using a standard Postgres build (Ubuntu) for the DB. 👌

[nelsonic]

I've edited ~T1h of screen recording down to T5m
with a few speed-ups where installation is happening:

Just have to record voiceover tomorrow morning when the house is quiet. 🤫

[ndrean]

@nelsonic I asked for Ansible because click-ops is for the braves who want to live dangerously 😬. Like using Docker without docker-compose or K8 without manifests. I saw: "You have the option to easily deploy Postgres clusters using the Console (UI) or from the command line with the ansible-playbook command."

Ansible palybook here -> https://github.com/vitabaks/autobase#command-line

[vitabaks]

Hi👋🙂

You might also be interested in a GitOps-based approach for managing database clusters. You can find more details here: https://autobase.tech/docs/management/gitops

[nelsonic]

I deliberately left the DaVinci Resolve project on the MacMini @home in Braga for the Xmas holidays because I know I'm not going to have a lot of quiet time to record the voiceover. 🎤
So will only pick this up again in the new year. ⏳

[ndrean]

A book on Ansible: https://github.com/pavankkasturi/books/blob/master/Ansible%20for%20DevOps.pdf

You can add this to your library: