BestHub
Sign in
Showing 100 articles max
Latest Popular
Architect Chen
Architect Chen
Apr 23, 2026 · Databases

The Most Complete Redis Configuration Guide with Illustrated Examples

This article provides a thorough walkthrough of Redis configuration, covering the location of the redis.conf file, how to list all settings with CONFIG GET *, modify parameters via CONFIG SET, and detailed explanations of common options such as bind address, port, timeout, log level, database count, daemonization, log file, client limits, memory limits, persistence settings, replication, and password protection, each illustrated with concrete command examples.

CONFIGPerformanceRedis
0 likes · 6 min read
The Most Complete Redis Configuration Guide with Illustrated Examples
Architect Chen
Architect Chen
Apr 23, 2026 · Databases

How Redis Handles 1 Million Concurrent Connections: 4 Key Techniques

Redis achieves million‑level concurrency by keeping all data in RAM, using epoll/kqueue for non‑blocking I/O, employing highly optimized data structures with O(1) or O(log N) operations, and evolving from a single‑threaded core to optional multi‑threaded I/O, boosting throughput up to 12×.

Data StructuresI/O MultiplexingIn-Memory
0 likes · 4 min read
How Redis Handles 1 Million Concurrent Connections: 4 Key Techniques
Sohu Tech Products
Sohu Tech Products
Apr 22, 2026 · Databases

How to Resolve ID Conflicts After Sharding? 5 Proven Solutions

When sharding databases, independent auto‑increment IDs can collide, causing data integrity issues; this article explains why the conflict occurs and walks through five practical solutions—including UUID, custom auto‑increment steps, segment mode, Snowflake, and Meituan Leaf—detailing their trade‑offs, performance, and implementation steps.

DatabaseID generationLeaf
0 likes · 15 min read
How to Resolve ID Conflicts After Sharding? 5 Proven Solutions
Ops Community
Ops Community
Apr 22, 2026 · Databases

Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide

When MySQL CPU usage spikes above 80% or hits 100%, this guide walks you through a systematic investigation—from confirming the MySQL process consumes CPU, checking system and MySQL status, analyzing connection counts, slow queries, lock waits, and configuration settings, to applying short‑term mitigations and long‑term architectural fixes.

CPUDatabase operationsPerformance tuning
0 likes · 17 min read
Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 22, 2026 · Databases

Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice

PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.

Apache AGEFull-Text SearchJSONB
0 likes · 39 min read
Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice
Java Baker
Java Baker
Apr 22, 2026 · Databases

A Step‑by‑Step SOP for Seamless Business Data Migration

This article outlines a comprehensive, risk‑controlled SOP for migrating business data—including model changes, storage shifts, incremental dual‑write, back‑filling, full and incremental consistency checks, read‑switching, and final decommissioning—backed by concrete SQL examples and visual diagrams.

Data ConsistencyData MigrationDatabase
0 likes · 6 min read
A Step‑by‑Step SOP for Seamless Business Data Migration
dbaplus Community
dbaplus Community
Apr 19, 2026 · Databases

Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search

This guide explains how traditional relational databases and SQL struggle with semantic queries needed for AI applications, introduces vector databases and HNSW indexing for efficient similarity search, compares their architectures, and presents a real‑world fraud detection system that combines both technologies.

AIB+TreeHNSW
0 likes · 17 min read
Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search
Ops Community
Ops Community
Apr 19, 2026 · Databases

How to Diagnose and Resolve MySQL CPU Spikes: A Complete Step‑by‑Step Guide

This guide walks you through identifying why MySQL CPU usage jumps, from confirming the MySQL process consumes CPU to checking connection counts, slow queries, lock waits, configuration settings, and business‑level traffic, and then provides short‑term mitigations and long‑term solutions such as read‑write splitting, sharding, and caching.

CPUDatabaseMonitoring
0 likes · 17 min read
How to Diagnose and Resolve MySQL CPU Spikes: A Complete Step‑by‑Step Guide
DataFunTalk
DataFunTalk
Apr 18, 2026 · Databases

How Will Apache Doris Evolve in 2026 to Power AI‑Driven Data Workloads?

The article outlines Apache Doris's 2026 roadmap, detailing how the database will shift from pure analytics to a unified AI‑enabled platform with enhanced semi‑structured data support, vector and hybrid search, agent‑focused capabilities, and expanded storage and lakehouse integrations to meet emerging AI workloads.

AI integrationApache DorisDatabase Roadmap
0 likes · 14 min read
How Will Apache Doris Evolve in 2026 to Power AI‑Driven Data Workloads?
Java Architect Handbook
Java Architect Handbook
Apr 18, 2026 · Databases

Redis Persistence Deep Dive: RDB, AOF, and Hybrid Strategies for Interview Success

This article provides a comprehensive analysis of Redis persistence mechanisms—including RDB snapshots, AOF append‑only logs, and the hybrid RDB+AOF mode—covering their architectures, trigger methods, performance trade‑offs, rewrite processes, interview‑focused questions, and practical recommendations for production environments.

AOFDatabaseHybrid
0 likes · 11 min read
Redis Persistence Deep Dive: RDB, AOF, and Hybrid Strategies for Interview Success
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2026 · Databases

Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices

This comprehensive guide explains why MySQL backup is essential, defines RPO/RTO, compares logical and physical tools, provides ready‑to‑run scripts for full, incremental, binlog, encryption and compression backups, details step‑by‑step recovery procedures, troubleshooting tips and monitoring recommendations for reliable database protection.

Database AdministrationRecoveryautomation
0 likes · 35 min read
Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices
Architect's Guide
Architect's Guide
Apr 18, 2026 · Databases

How to Import 1 Billion Records into MySQL at Lightning Speed

This article analyzes the constraints of loading a billion 1‑KB log records from HDFS/S3 into MySQL, evaluates single‑table limits, proposes batch inserts, sharding, file‑reading techniques, task coordination with Redis, Redisson, and Zookeeper, and offers practical performance‑tuning recommendations.

Bulk InsertPerformance tuningRedis
0 likes · 21 min read
How to Import 1 Billion Records into MySQL at Lightning Speed
StarRocks
StarRocks
Apr 16, 2026 · Databases

Why Traditional Databases Stall AI Agents—and How StarRocks Overcomes the Bottleneck

Traditional databases were built for low‑frequency, human‑driven queries, but AI agents generate dozens of concurrent, sub‑second queries that expose architectural limits, and StarRocks addresses these challenges with self‑healing optimization, real‑time data pipelines, extreme concurrency handling, and seamless lakehouse access.

Database ConcurrencyLakehouseStarRocks
0 likes · 13 min read
Why Traditional Databases Stall AI Agents—and How StarRocks Overcomes the Bottleneck
Java Companion
Java Companion
Apr 16, 2026 · Databases

Is Running MySQL in Docker Really a Bad Idea?

This article dissects the common claim that MySQL should not be run in Docker by explaining the underlying design mismatch, measuring I/O overhead, examining persistence and resource‑isolation pitfalls, reviewing replication challenges, and presenting real‑world cases from JD and Tongcheng to show when containerization is safe and when it isn’t.

ContainerizationData PersistenceDocker
0 likes · 12 min read
Is Running MySQL in Docker Really a Bad Idea?
Architecture & Thinking
Architecture & Thinking
Apr 16, 2026 · Databases

Mastering Database Performance: From Slow Queries to Deadlock Resolution

This guide presents a systematic, end-to-end diagnostic workflow for high-concurrency database environments, covering slow-SQL detection, execution-plan analysis, lock-conflict monitoring, deadlock investigation, and practical optimization techniques, illustrated with real-world cases, commands, and tool integrations to swiftly resolve performance bottlenecks.

Database DiagnosticsLock MonitoringPerformance tuning
0 likes · 18 min read
Mastering Database Performance: From Slow Queries to Deadlock Resolution