This time with links around the topics of DevOps, SRE, and Ops. I hope you enjoy it.
Postgres links
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.
explain.dalibo.com - PostgreSQL EXPLAIN
Visualizing and understanding your PostgreSQL execution plans made easy.
Container/Orchestration
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.
DevOps software / openSource tools
highlight.io: The open source monitoring platform.
highlight.io 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.
Free tool to help understand PG’s explain charts