BestHub
Sign in
dbaplus Community
Author

dbaplus Community

Enterprise-level professional community for Database, BigData, and AIOps. Daily original articles, weekly online tech talks, monthly offline salons, and quarterly XCOPS&DAMS conferences—delivered by industry experts.

2.3k
Articles
1
Likes
3.9k
Views
0
Comments
Recent Articles

Latest from dbaplus Community

100 recent articles max
dbaplus Community
dbaplus Community
May 10, 2026 · Operations

How a Single FFmpeg Command Can Cut CDN Video Bandwidth Costs by 90%

An investigation revealed that a 1 GB MP4 video streamed to 2,500 users consumed 120 TB of CDN bandwidth because the file’s moov box was placed at the end and the audio‑video tracks were poorly interleaved, causing thousands of HTTP 206 range requests; moving the moov box to the file header with a simple ffmpeg command eliminated the excess requests and reduced bandwidth usage to the video’s actual size.

CDNFFmpegbandwidth
0 likes · 12 min read
How a Single FFmpeg Command Can Cut CDN Video Bandwidth Costs by 90%
dbaplus Community
dbaplus Community
May 8, 2026 · Operations

Why Debian Beats Ubuntu as the Ideal Daily‑Driver Linux Distro

The article compares Debian and Ubuntu, showing how Debian’s community‑driven purity, stable release model, broad hardware support, flexible desktop choices, classic APT packaging, and strong community make it a superior daily‑driver Linux distribution.

APTDebianFree Software
0 likes · 10 min read
Why Debian Beats Ubuntu as the Ideal Daily‑Driver Linux Distro
dbaplus Community
dbaplus Community
May 6, 2026 · Backend Development

Why Scheduled Tasks Fail for Million‑Scale Order Cancellation and How Redis Solves It

The article dissects a common interview question about automatically canceling unpaid orders after 30 minutes, explains why naïve cron‑based scans are unsuitable for tens of millions of rows, and presents three progressively robust solutions using Redis expiration, Redis ZSet polling, and message‑queue or time‑wheel architectures.

Delayed TaskMessage QueueOrder Cancellation
0 likes · 10 min read
Why Scheduled Tasks Fail for Million‑Scale Order Cancellation and How Redis Solves It
dbaplus Community
dbaplus Community
May 5, 2026 · Artificial Intelligence

How Claude Transforms SQL Workloads in the Dewu App Data Warehouse

The article examines Claude Code's deep integration into Dewu's e‑commerce data warehouse, outlining a decoupled cognitive‑runtime architecture, standardized I/O contracts, concrete performance gains across tagging, modeling, reporting and testing, and a comprehensive risk‑governance framework.

AI Agentic WorkflowCode LLMPerformance Optimization
0 likes · 23 min read
How Claude Transforms SQL Workloads in the Dewu App Data Warehouse
dbaplus Community
dbaplus Community
May 5, 2026 · Artificial Intelligence

The True Nature of Agent Memory: Deep Dive into Architecture and Design

The article analyses why a real agent must have memory, defining memory as an external state that feeds decision‑making, proposing a three‑part architecture (Raw Ledger, Views, Policy), contrasting parametric and non‑parametric approaches, and detailing bottlenecks, temporal handling, and procedural extensions.

Agent MemoryRetrievalmemory architecture
0 likes · 46 min read
The True Nature of Agent Memory: Deep Dive into Architecture and Design
dbaplus Community
dbaplus Community
May 4, 2026 · Industry Insights

Beyond Linux: 9 Legendary Open‑Source Operating Systems You’ve Probably Never Heard Of

While Linux dominates the open‑source OS conversation, nine historic and emerging systems—including Plan 9, Haiku, Minix, HelenOS, AROS, ReactOS, FreeDOS, GNU Hurd, and the BSD family—offer unique architectures, legacy influences, and modern breakthroughs that showcase the true diversity of open‑source operating systems.

BSDFreeDOSHaiku
0 likes · 8 min read
Beyond Linux: 9 Legendary Open‑Source Operating Systems You’ve Probably Never Heard Of
dbaplus Community
dbaplus Community
May 3, 2026 · Fundamentals

What Is 127.0.0.2? A Veteran Ops Engineer’s Surprising Discovery

The article explains that the entire 127.0.0.0/8 block consists of loopback addresses, shows how addresses like 127.0.0.2 and 127.0.1.1 are reachable, and demonstrates practical uses such as isolating services, simulating clusters, and the special role of 127.0.1.1 on Debian systems.

127.0.0.0/8Linux networkinghosts file
0 likes · 7 min read
What Is 127.0.0.2? A Veteran Ops Engineer’s Surprising Discovery
dbaplus Community
dbaplus Community
May 2, 2026 · Artificial Intelligence

Inside Claude Code: A Deep Dive into Its Powerful Agent Architecture

This article provides a comprehensive technical analysis of Claude Code, covering its project scale, two‑layer agent loop design, five design principles, tool system architecture, fine‑grained permission model, multi‑agent collaboration strategies, context‑engineered system prompts, and a custom React‑based terminal UI, all illustrated with concrete code excerpts and diagrams.

AI AgentClaude CodeContext Engineering
0 likes · 38 min read
Inside Claude Code: A Deep Dive into Its Powerful Agent Architecture
dbaplus Community
dbaplus Community
May 1, 2026 · Operations

Why a Simple Nginx Change Made All Gateway Requests Return 400 (And How to Fix It)

A production incident caused by replacing two Nginx reverse proxies introduced an upstream name with an underscore, resulting in invalid Host headers and 400 Bad Request responses from Spring Cloud Gateway; the article details the step‑by‑step investigation, evidence from logs, tcpdump, and code, and presents configuration fixes to restore normal operation.

HTTP 400NginxSRE
0 likes · 15 min read
Why a Simple Nginx Change Made All Gateway Requests Return 400 (And How to Fix It)
dbaplus Community
dbaplus Community
Apr 29, 2026 · Backend Development

Choosing a Scheduling Solution: Quartz vs XXL‑Job vs @Scheduled – Core Principles, Use Cases, Pros & Cons

The article provides a detailed comparison of three Java scheduling solutions—Spring's @Scheduled, Quartz, and XXL‑Job—covering their underlying mechanisms, key features, typical scenarios, common pitfalls, and practical recommendations to help developers select the most suitable option for their projects.

@ScheduledBackendDistributed
0 likes · 18 min read
Choosing a Scheduling Solution: Quartz vs XXL‑Job vs @Scheduled – Core Principles, Use Cases, Pros & Cons