ITFROMZERO – Share tobe shared!

Secure phpMyAdmin Installation on Linux: Authentication, IP Restrictions, and Nginx Reverse Proxy

By admin July 8, 2026

A practical guide to installing and securing phpMyAdmin on Linux: combining HTTP Basic Auth, IP whitelisting, and deployment behind an Nginx Reverse Proxy. Includes fail2ban and rate limiting configuration to prevent brute-force attacks.

MySQL

gh-ost: Zero-Downtime MySQL Schema Changes — GitHub’s Answer to pt-osc

By admin July 8, 2026

gh-ost is a tool developed by GitHub for making MySQL schema changes on tables with tens of millions of rows without any downtime. Unlike pt-osc which uses triggers, gh-ost reads the binlog directly — safer, with the ability to pause/resume and adjust speed in realtime throughout the migration.

Centos

Setting Up Dovecot + Postfix on CentOS Stream 9: Secure IMAP/POP3 Mail Server with SSL/TLS and SELinux

By admin July 8, 2026

A complete guide to building a mail server on CentOS Stream 9 with Dovecot and Postfix — supporting IMAP/POP3, SASL authentication, SSL/TLS, and SELinux enforcing. Covers approach comparisons, trade-off analysis, and troubleshooting the most common issues including proper SELinux configuration.

Linux

Writing udev Rules on Linux: Fixed Network Interface Names and Auto-triggering Scripts on USB Plug-in

By admin July 8, 2026

udev rules give you control over how Linux names hardware devices — from network interfaces to USB serial ports. This guide covers writing practical rules to assign fixed interface names by MAC address, create persistent symlinks for USB devices, and auto-run scripts when a device is plugged in.

Linux

A Practical Guide to jq on Linux: Filtering and Processing JSON from APIs in the Terminal

By admin July 8, 2026

When you're debugging production at 2 AM staring at an unreadable wall of JSON in your logs, jq saves you more time than any other approach. This guide compares jq against grep and Python for handling JSON in the terminal, covering everything from basic syntax to filtering Docker containers and Kubernetes API responses in practice.

Database

YugabyteDB: A Guide to Setting Up PostgreSQL-Compatible Distributed SQL with Auto-Sharding and Automatic Fault Tolerance

By admin July 8, 2026

YugabyteDB is a PostgreSQL-compatible distributed SQL database with auto-sharding, automatic fault tolerance, and multi-region deployment — no changes to your SQL or ORM required. This guide covers installation from a single-node Docker setup to a real 3-node cluster, along with practical tips for working with distributed databases.

Development

Building CLIs with Rust and Clap: Goodbye to Your Tangled Bash Scripts

By admin July 8, 2026

Replace Bash scripts with Rust and Clap to build safe, high-performance CLI tools. A detailed guide on configuring subcommands and optimizing binaries for production environments.

Monitoring

Mastering MinIO Performance: How to Set Up Prometheus & Grafana to Monitor IOPS, Throughput, and Capacity

By admin July 8, 2026

Is your MinIO system slow for no apparent reason? This guide will help you set up Prometheus and Grafana to monitor IOPS, throughput, and forecast disk capacity like a pro.

Git

tig Guide: A Visual Terminal UI for Git to Browse Commits, Stage Line by Line, and Fix Merge Conflicts

By admin July 7, 2026

tig is a Terminal UI for Git that lets you browse commit history, stage individual lines of changes, and resolve merge conflicts visually — all without leaving the terminal. A guide to installation, essential keyboard shortcuts, and a practical workflow for integrating tig into your daily development routine.

Monitoring

How to Install and Configure Grafana Beyla: Automatic Application Monitoring Without Code Changes Using eBPF for Go, Python, and Node.js

By admin July 7, 2026

Grafana Beyla uses eBPF to automatically collect metrics and traces from Go, Python, and Node.js applications — no code changes, no SDK installation required. This post walks through installing and configuring Beyla, and shares real-world results after 6 months running on production with Prometheus + Grafana.

Deploying a MongoDB Sharded Cluster with Docker Compose: Data Sharding for Large-Scale Applications

Juju and Charmed Operators on Ubuntu: Automating Deployment and Application Lifecycle Management with a Model-Driven Approach

Installing Proxmox VE on Raspberry Pi 5: Ultra Low-Cost ARM64 Home Lab with Debian Port

Manage MySQL Like a Pro: Boost Performance 200% with the mycli and mytop Duo

Building Spring Boot 3 & PostgreSQL REST APIs: From ‘Working’ Code to Production-Ready Systems

Building 2FA with Node.js: Don’t Let Passwords Be Your Only Line of Defense

Building a Batch Video Processing Automation System with Python and MoviePy: From Manual to ‘Industrialized’

Migrating MSSQL to MySQL: Pro Tips for Troubleshooting and Data Type Mismatches

Repository Rescue: Mastering git fsck to Recover Code and Fix Data Errors

Optimize Windows Virtual Machines to Run ‘Silky Smooth’ with VMware OS Optimization Tool (OSOT)

Secure phpMyAdmin Installation on Linux: Authentication, IP Restrictions, and Nginx Reverse Proxy

gh-ost: Zero-Downtime MySQL Schema Changes — GitHub’s Answer to pt-osc

Setting Up Dovecot + Postfix on CentOS Stream 9: Secure IMAP/POP3 Mail Server with SSL/TLS and SELinux

Writing udev Rules on Linux: Fixed Network Interface Names and Auto-triggering Scripts on USB Plug-in

A Practical Guide to jq on Linux: Filtering and Processing JSON from APIs in the Terminal

YugabyteDB: A Guide to Setting Up PostgreSQL-Compatible Distributed SQL with Auto-Sharding and Automatic Fault Tolerance

Building CLIs with Rust and Clap: Goodbye to Your Tangled Bash Scripts

Mastering MinIO Performance: How to Set Up Prometheus & Grafana to Monitor IOPS, Throughput, and Capacity

tig Guide: A Visual Terminal UI for Git to Browse Commits, Stage Line by Line, and Fix Merge Conflicts

How to Install and Configure Grafana Beyla: Automatic Application Monitoring Without Code Changes Using eBPF for Go, Python, and Node.js