ITPUB
Author

ITPUB

Official ITPUB account sharing technical insights, community news, and exciting events.

2.8k
Articles
0
Likes
899
Views
0
Comments
Recent Articles

Latest from ITPUB

100 recent articles max
ITPUB
ITPUB
Dec 31, 2025 · Operations

Essential Advanced Linux Commands Every Sysadmin Should Master

This guide compiles 100 high‑impact Linux commands covering file systems, networking, monitoring, security, containers, log analysis, and automation, each chosen for its advanced utility, cross‑distribution compatibility, and real‑world relevance.

AutomationCommand LineLinux
0 likes · 17 min read
Essential Advanced Linux Commands Every Sysadmin Should Master
ITPUB
ITPUB
Dec 30, 2025 · Operations

Master Linux Network Speed Testing: From Ping to Advanced Tools

This guide walks you through a complete set of Linux network‑speed testing utilities—from the built‑in ping command to curl/wget downloads, Speedtest‑CLI, iperf3, iftop, nload, nethogs, bmon and vnstat—explaining installation, core metrics, usage examples, and practical tips for accurate measurement and troubleshooting.

Linuxiftopiperf3
0 likes · 10 min read
Master Linux Network Speed Testing: From Ping to Advanced Tools
ITPUB
ITPUB
Dec 29, 2025 · Databases

Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25

VectorChord‑BM25 is a PostgreSQL extension that adds native BM25 ranking and tokenization, delivering up to three‑fold query‑per‑second improvements over ElasticSearch while maintaining comparable relevance scores, and includes detailed installation, usage examples, and performance analysis.

BM25Database ExtensionFull-text search
0 likes · 17 min read
Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25
ITPUB
ITPUB
Dec 28, 2025 · Backend Development

AI-Driven DDD Refactoring: From Monolithic Service Packages to Modular Architecture

Using AI to assist domain-driven design, this case study details how a monolithic Taobao service-package system was analyzed, restructured, and refactored, reducing development effort from 5-8 person-days per package to configuration-based implementation while eliminating duplicated code and improving modularity, testability, and scalability.

AIDomain-Driven Designrefactoring
0 likes · 16 min read
AI-Driven DDD Refactoring: From Monolithic Service Packages to Modular Architecture
ITPUB
ITPUB
Dec 27, 2025 · Fundamentals

How to Test Membership in 4 Billion Numbers Using Only 1 GB Memory

This article explains how to determine whether a given unsigned integer belongs to a set of 4 billion distinct numbers within a 1 GB memory limit, comparing a bitmap approach with a Bloom filter, providing detailed implementation steps and C++ code examples for both methods.

BitmapC++bloom filter
0 likes · 8 min read
How to Test Membership in 4 Billion Numbers Using Only 1 GB Memory
ITPUB
ITPUB
Dec 26, 2025 · Databases

How to Migrate 100 Billion ClickHouse Rows to Doris: Three Practical Strategies

When a ClickHouse cluster needed to be decommissioned, the author evaluated three migration approaches—using Doris' ClickHouse catalog, exporting to files with Broker/Stream Load, and leveraging Spark—to move roughly 100 billion rows to Doris, comparing their complexity, reliability, and performance.

CatalogClickHouseSQL
0 likes · 9 min read
How to Migrate 100 Billion ClickHouse Rows to Doris: Three Practical Strategies
ITPUB
ITPUB
Dec 20, 2025 · Databases

Why MySQL IN Clauses Hit Limits and How to Optimize Them

This article explains the reasons behind MySQL IN‑clause parameter limits, the performance impact of large IN lists, and provides practical optimization techniques such as splitting queries in application code and using temporary tables with EXISTS to improve efficiency.

IN clauseMySQLSQL Optimization
0 likes · 5 min read
Why MySQL IN Clauses Hit Limits and How to Optimize Them
ITPUB
ITPUB
Dec 18, 2025 · Databases

Why Did Our Oracle RAC Cluster Stall? A Real‑World AWR Diagnosis

A client reported sudden Oracle database slowdown, prompting a post‑mortem analysis using AWR and TFA data that revealed GC bottlenecks, RAC heartbeat packet loss, and an intermittent storage link failure, ultimately resolved by disabling the faulty port and restarting the affected node.

AWROracleRAC
0 likes · 5 min read
Why Did Our Oracle RAC Cluster Stall? A Real‑World AWR Diagnosis
ITPUB
ITPUB
Dec 16, 2025 · Backend Development

Nginx vs Envoy: Real‑World Performance Benchmark and Deployment Guide

This article translates and expands Anton Putra's benchmark, detailing how to deploy Nginx and Envoy on AWS with Terraform and Ansible, run HTTP, HTTPS, and gRPC load tests using K6, measure CPU and latency with Prometheus, and compare the resulting throughput and stability of both proxies.

EnvoyK6Nginx
0 likes · 8 min read
Nginx vs Envoy: Real‑World Performance Benchmark and Deployment Guide
ITPUB
ITPUB
Dec 14, 2025 · Cloud Native

What Can Replace MinIO? A Deep Dive into Ceph, SeaweedFS, Garage, and RustFS

With MinIO entering maintenance mode, this article evaluates open‑source S3‑compatible alternatives—Ceph, SeaweedFS, Garage, and RustFS—detailing their strengths, limitations, security concerns, and practical deployment tips, while concluding that none yet offers a perfect drop‑in replacement.

CephMinIOObject Storage
0 likes · 9 min read
What Can Replace MinIO? A Deep Dive into Ceph, SeaweedFS, Garage, and RustFS