Dev-Links #22 - Ops/DevOps/SRE links

21st April 2023 – 626 words

This time with links around the topics of DevOps, SRE, and Ops. I hope you enjoy it.

Some indexing best practices - pgMustard

We all know that indexing is important, but it can be difficult to know where to start. In this post, my aim is to collate some of the best advice I’ve seen for indexing Postgres, and simplify it for folks just getting started.

Is your Postgres ready for production?

Craig gets you ready for production with this quick checklist of Postgres essentials. - PostgreSQL EXPLAIN

Visualizing and understanding your PostgreSQL execution plans made easy.

Free tool to help understand PG’s explain charts


How We Develop and Operate Pirsch

Learn how we operate Pirsch on Hetzner cloud using HashiCorp Nomad, Traefik, Letsencrypt and more.

One (German) company’s stack based around Hetzner cloud and Hashicorp tools

GitHub - timohirt/terraform-provider-hetznerdns: Terraform provider for Hetzner DNS

Terraform provider for Hetzner DNS.

6 Docker Compose Best Practices for Dev and Prod — ReleaseHub

Docker Compose is an excellent optimization tool for development and production. Learn best practices for Docker Compose

21 Analytics / GitLab Runner cloud-init · GitLab

Set up your own GitLab Runner within seconds using cloud-init on Hetzner, Exoscale, Azure or any other public cloud provider.

Comes in handy to auto set up Gitlab Runner like this.

mrsked/mrsk: Deploy web apps anywhere.

MRSK deploys web apps anywhere from bare metal to cloud VMs using Docker with zero downtime. It uses the dynamic reverse-proxy Traefik to hold requests while the new application container is started and the old one is stopped. It works seamlessly across multiple hosts, using SSHKit to execute commands. It was built for Rails applications, but works with any type of web app that can be containerized with Docker.

Very simplified approach to deployment. Used it on a side app already and happy with the result. Comparable with docker-compose, but for manual orchestration.

Load Balancing

Great explanation of Load Balancers from first principles

DevOps software / openSource tools The open source monitoring platform. is the open source monitoring platform that gives you the visibility you need.

Contender for a Sentry/Logging replacement. Also with a self hosted option

grafana/loki: Like Prometheus, but for logs.

Loki: like Prometheus, but for logs. Loki is a horizontally-scalable, highly-available, multi-tenant log aggregation system inspired by Prometheus. It is designed to be very cost effective and easy to operate.

Looking for a new Logging setup, this might fit our current Prometheus/Grafana quite good.

Ansible Molecule

Molecule project is designed to aid in the development and testing of Ansible roles. Molecule provides support for testing with multiple instances, operating systems and distributions, virtualization providers, test frameworks and testing scenarios.