ITFROMZERO - Share tobe shared!

How to Use Flyway for MySQL Schema Migration and Version Control in CI/CD

By IT From Zero October 3, 2026

Learn how to use Flyway to automate schema migrations and version control for MySQL databases. Eliminate schema drift during deployments and integrate safely into your CI/CD pipeline.

Database

Apache Doris Setup and Usage Guide: Building a Real-Time Data Warehouse and Analytics Dashboard

By IT From Zero October 3, 2026

A comprehensive guide to deploying a distributed data warehouse with Apache Doris. Learn MPP architecture, Aggregate/Unique table design, Stream Load ingestion, and real-time dashboard optimization.

Monitoring

Guide to Monitoring Self-Hosted GitHub Actions Runners with Prometheus and Grafana: Track Runner Health, Job Queue, and Build Duration

By IT From Zero October 2, 2026

Running self-hosted GitHub Actions runners without monitoring leaves CI/CD teams vulnerable to unexpected crashes and clogged job queues. This guide covers a comprehensive monitoring solution for runner infrastructure, job queues, and build duration using Prometheus and Grafana.

Linux

How to Use Snapper on Btrfs: Automatic Snapshots and Linux Rollback on Failed Updates

By IT From Zero October 2, 2026

Protect Linux servers from broken kernel and package updates using Btrfs and Snapper. A comprehensive guide to automated snapshots and 30-second system rollbacks.

VMware

Configuring VM-Host and VM-VM Anti-Affinity Rules on VMware vSphere: Avoiding the Half-Baked High Availability Trap

By IT From Zero October 2, 2026

Running paired VMs for redundancy, yet a single ESXi host failure took down your entire service? Learn how to configure VM-VM and VM-Host Anti-Affinity Rules on vSphere to avoid bad placement traps.

VMware

Configuring Remote Syslog on VMware ESXi: Centralize Logs to a Syslog Server

By IT From Zero October 2, 2026

A detailed guide on configuring Remote Syslog on VMware ESXi using the esxcli CLI and Host Client. Centralize logs securely to a Syslog Server and minimize the risk of log loss during hardware failures.

Database

A Guide to pgBackRest for PostgreSQL: Parallel Backups, S3 Compression, and PITR

By IT From Zero October 2, 2026

Real-world incident response for accidental production data loss at midnight with pgBackRest: Multi-threaded S3 backups and precise Point-in-Time Recovery (PITR).

Centos

How to Configure Two-Factor Authentication (2FA) for SSH on CentOS Stream 9 with Google Authenticator and PAM

By IT From Zero October 2, 2026

A step-by-step guide to setting up two-factor authentication (2FA) for SSH on CentOS Stream 9 using Google Authenticator and PAM. Combining SSH keys with TOTP OTP keeps your server secure even if private keys are compromised.

Python

A Guide to Using Alembic in Python: Database Migration Management for SQLAlchemy

By IT From Zero October 2, 2026

Managing database schema changes is critical as Python projects scale. Here is a comprehensive guide to setting up Alembic with SQLAlchemy to automate migrations, sync via Git, and perform safe rollbacks.

Artificial Intelligence tutorial - IT technology blog

Using ChromaDB with Python: Build a Lightweight Local Vector Database for AI Applications

By IT From Zero October 2, 2026

Suffering from OOM killer memory crashes due to in-memory NumPy vectors? Here is how to integrate ChromaDB PersistentClient in Python for a lightweight, robust local vector database.

Building Your Own MCP Server with TypeScript: Connect AI Assistants to Internal Systems

Mastering TanStack Query v5 in React: Practical Server State Management, Caching, and Optimistic Updates

Installing ModSecurity v3 and OWASP CRS on Nginx Ubuntu: Building a Production-Ready Web Server WAF

Centralized Cloudflare Traffic and Security Monitoring with Cloudflare Exporter, Prometheus, and Grafana

Guide to E2B Code Interpreter with Python: Building a Secure Sandbox for AI Agents

A Guide to bpftrace and BCC on Fedora: Linux Performance Analysis and Diagnostics with eBPF

Optimizing Index Merge in MySQL: Understanding Intersection, Union, and Handling Optimizer Missteps

How to Create Systemd Services and Systemd Timers on Ubuntu: A Robust Crontab Alternative

Configuring the FEDERATED Storage Engine in MySQL: Connect and Query Remote Tables

SGLang on Linux Guide: Accelerate LLM Inference and Optimize RadixAttention for AI APIs

How to Use Flyway for MySQL Schema Migration and Version Control in CI/CD

Apache Doris Setup and Usage Guide: Building a Real-Time Data Warehouse and Analytics Dashboard

Guide to Monitoring Self-Hosted GitHub Actions Runners with Prometheus and Grafana: Track Runner Health, Job Queue, and Build Duration

How to Use Snapper on Btrfs: Automatic Snapshots and Linux Rollback on Failed Updates

Configuring VM-Host and VM-VM Anti-Affinity Rules on VMware vSphere: Avoiding the Half-Baked High Availability Trap

Configuring Remote Syslog on VMware ESXi: Centralize Logs to a Syslog Server

A Guide to pgBackRest for PostgreSQL: Parallel Backups, S3 Compression, and PITR

How to Configure Two-Factor Authentication (2FA) for SSH on CentOS Stream 9 with Google Authenticator and PAM

A Guide to Using Alembic in Python: Database Migration Management for SQLAlchemy

Using ChromaDB with Python: Build a Lightweight Local Vector Database for AI Applications