Index Condition Pushdown Optimization in MySQL

Big Idea Getting under the hood of database implementations is starting to become an area of growing interest to me. Early in my career I was always content with SQL as an interface to datastore that ‘just works’. That is, until it doesn’t anymore. It’s at those points that I am now being pushed to understand why a particular database implementation has particular behaviour charatersitics in different circumstances. Further, I have never crossed-paths with a professional DBA and oftentimes feel left like there’s a whole sphere of mystery for me here....

June 2, 2025 · 2 min

Making my K8s Control Plane HA

Big Idea For a while the K8s cluster in my homelab has been in the precarious situation of only having a single master node. This has bitten me a couple of times when the master node (i.e the “server node” in k3s) has been snafu’ed. Now that I have compute available on my proxmox server, I want to take the time to virtualize two additional master nodes. Doing this will require understanding a few things at the outset:...

February 23, 2025 · 3 min

Tenets of Engineering

Big Idea I am getting to the stage of my career now where I have started picking up guiding principles that guide my socio-technical endeavors. I am sure I will continue to learn more and add them here or come back revise these with more wisdom and insight but what I want to start here is a collection of tenets. These tenets are not implementation details or design patterns but are more like paradigms for how we relate to problems, the natural systems that emerge from people thrown into teams, and more....

February 6, 2025 · 2 min

TrueNAS Backups & Restore with B2

Big Idea The goal of this post will be to capture the steps required for the backup and restore process of my TrueNAS server. Currenty, my TrueNAS server consists of two 4TB drives in a vdev with a RAID1 (Mirror) config. My goal is to back this up to Backblaze’s S3-compatible B2 storage and test recovery before migrating data out of my old 1TB SSD. Once I have these backups in places the 3-2-1 rule will be satisfied:...

January 23, 2025 · 6 min

ZFS: A Primer

Big Idea Zettabit File System (ZFS) is a file system that is very popular in the Homelab community for it’s powerful capabilities as a file system and volume manager. It is designed to ensure data integrity and scalbility. While I am not an expert in ZFS, I hope to create guide here that outlines some of the fundamantal concepts of ZFS that I can return to over time. ZFS has a few key features that I will outline here:...

January 5, 2025 · 5 min

Load Testing Applications with Locust

Big Idea I was recently tasked with configuring automated load tests to validate the health of a service under load and to identify bottlenecks and limits at which the service became overloaded. Up until this point, I had not worked first-hand with any load-testing frameworks. Although there are many great load testing tools out there like JMeter, K6s, and Locust, I decided to get started with Locust as it is a framework I had heard of before and is a pure Python framework (Python is the language I think in right now)....

July 22, 2024 · 8 min