ITNotes - Page 20 of 83 - From Terminal to Cloud

MySQL Schema Migrations at Scale: A Deep Dive into gh-ost

May 17, 2026

Schema migrations on large MySQL tables don't have to cause downtime. This guide explores the triggerless approach of gh-ost, comparing it with native DDL and pt-osc while providing a step-by-step migration workflow.

HomeLab

Proxmox SDN Guide: Build Complex Virtual Networks Without the Hardware Headache

May 16, 2026

Ditch the messy cables and expensive managed switches. This guide shows you how to master Proxmox SDN to build automated, isolated, and scalable virtual networks for your HomeLab.

Security

Killing the Manual Audit: Automated Android Security with MobSF and Docker

May 16, 2026

Ditch manual decompilation. Learn to deploy MobSF on Docker for rapid Android security audits, catching hardcoded secrets and OWASP vulnerabilities in minutes.

Database

MySQL Sharding at Scale: A Practical Guide to Vitess on Kubernetes

May 16, 2026

Scaling MySQL horizontally doesn't have to be a nightmare. This hands-on guide walks you through sharding your database using Vitess on Kubernetes, from setup to VSchema configuration.

Ditch the Subscription: Build a Private AI Coding Assistant with Continue and Ollama

May 16, 2026

Ditch GitHub Copilot. Learn how to build a fully self-hosted, private AI coding assistant using Continue.dev and Ollama with local LLMs like DeepSeek-Coder-V2.

Database

Beyond Lat/Lon: A Pro Guide to Mastering PostGIS on PostgreSQL

May 16, 2026

Learn how to move beyond basic latitude and longitude storage. This guide covers PostGIS installation, GEOGRAPHY vs GEOMETRY types, and how GIST indexing can make your spatial queries 100x faster.

DevOps

Stop Guessing Your Uptime: A Practical Guide to SLOs with Prometheus and Sloth

May 16, 2026

Tired of noisy alerts? Learn how to implement SRE-style SLOs and SLIs. This guide walks you through using Sloth and Prometheus to manage your reliability and Error Budget effectively.

Database

Zero-Downtime Database Upgrades: A Survival Guide to Blue-Green Deployment

May 16, 2026

Forget the 2 AM panic. I walk through how to use Blue-Green deployment and logical replication to upgrade PostgreSQL and MySQL with zero downtime and total control.

DevOps

Automating API Testing in CI/CD with Postman and Newman: 6 Months of Production Reality

May 16, 2026

Based on 6 months of production use, this guide explains how to integrate Postman and Newman into CI/CD pipelines to catch API bugs before they hit production.

Deploy FerretDB on Docker: MongoDB-Compatible Open Source Database Built on PostgreSQL

Practical Web Security: Hunting XSS, SQLi, and IDOR with Burp Suite Community

Deploy OpenCTI on Docker: Build Your Own Threat Intelligence Lab

Beyond Boolean Soup: Architecting Robust React Logic with XState

Why Is My Linux Load Average High Despite Low CPU Usage?

Beyond APT: A Field Guide to Snap, Flatpak, and AppImage

Native MySQL High Availability: A Practical Guide to InnoDB Cluster and Router

Shipping Cross-Platform: A Production-Grade Guide to Flutter and Dart

Self-Hosting Penpot on Docker: The Private, Open-Source Figma Alternative

Reboot Linux in Seconds: Using kexec to Skip BIOS and POST

MySQL Schema Migrations at Scale: A Deep Dive into gh-ost

Proxmox SDN Guide: Build Complex Virtual Networks Without the Hardware Headache

Killing the Manual Audit: Automated Android Security with MobSF and Docker

MySQL Sharding at Scale: A Practical Guide to Vitess on Kubernetes

Ditch the Subscription: Build a Private AI Coding Assistant with Continue and Ollama

Beyond Lat/Lon: A Pro Guide to Mastering PostGIS on PostgreSQL

Stop Guessing Your Uptime: A Practical Guide to SLOs with Prometheus and Sloth

Zero-Downtime Database Upgrades: A Survival Guide to Blue-Green Deployment

Automating API Testing in CI/CD with Postman and Newman: 6 Months of Production Reality