BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Aug 12, 2026 · Databases

ZestKV Achieves 2.3× SET Write Throughput, Surpassing pika3.5 at 700k QPS

By parallelizing both the write side and the response side—using multi‑queue write concurrency, overlapping network and CPU work, batch wake‑ups, and connection‑based sharding—ZestKV raises SET request throughput from 310 k to 700 k QPS, more than double pika 3.5, while preserving full consistency and durability guarantees.

ParallelismPerformance OptimizationZestKV
0 likes · 12 min read
ZestKV Achieves 2.3× SET Write Throughput, Surpassing pika3.5 at 700k QPS
SpringMeng
SpringMeng
Aug 12, 2026 · Databases

RedisInsight: The Official High‑Performance GUI for Redis

This article introduces RedisInsight, the official visual management tool for Redis, outlines its key features, provides step‑by‑step installation on Linux and Kubernetes, and demonstrates basic usage for monitoring, querying, and memory analysis through the GUI.

GUIKubernetesLinux
0 likes · 7 min read
RedisInsight: The Official High‑Performance GUI for Redis
Cloud Architecture
Cloud Architecture
Aug 11, 2026 · Databases

Redis Sentinel Deep Dive: Leader Election, Failover Mechanics, and Production Best Practices

This article dissects Redis Sentinel’s high‑availability workflow—from failure detection, SDOWN/ODOWN states, and quorum logic to leader election, replica promotion, and configuration propagation—while illustrating each step with a real‑world e‑commerce cache case, detailed configuration snippets, Kubernetes deployment patterns, Spring Boot integration, and operational playbooks for observability and fault‑injection testing.

FailoverKubernetesRedis
0 likes · 48 min read
Redis Sentinel Deep Dive: Leader Election, Failover Mechanics, and Production Best Practices
Raymond Ops
Raymond Ops
Aug 11, 2026 · Databases

How to Diagnose MySQL Slow Queries: From Log Capture to Index Optimization

This guide walks MySQL operators through a complete slow‑query troubleshooting workflow—starting with enabling and analyzing the slow‑query log, using pt‑query‑digest and EXPLAIN to pinpoint index, SQL, schema, configuration or hardware bottlenecks, and then applying concrete optimizations such as proper indexing, cursor pagination, JOIN tuning, and server‑level parameter tweaks.

Buffer PoolEXPLAINJOIN tuning
0 likes · 33 min read
How to Diagnose MySQL Slow Queries: From Log Capture to Index Optimization
liandk
liandk
Aug 11, 2026 · Databases

Mastering SELECT: The Most Used SQL Query for Beginners

SELECT is the most frequently used SQL command, handling about 80% of data‑related work; this guide explains its core role, basic operations such as selecting all rows, specific columns, distinct values, and row limits, shows practical code examples, and advises against using SELECT * for better performance.

Data RetrievalSELECTSQL
0 likes · 2 min read
Mastering SELECT: The Most Used SQL Query for Beginners
Cloud Architecture
Cloud Architecture
Aug 10, 2026 · Databases

Master‑Slave Replication in Redis: Core Mechanics Explained and Production Deployment

This article provides a comprehensive, production‑focused analysis of Redis master‑slave replication, covering its internal state machine, full and partial sync processes, configuration pitfalls, performance bottlenecks, consistency trade‑offs, and practical deployment patterns with Docker, Kubernetes, and Spring Boot.

Docker ComposeKubernetesRedis
0 likes · 38 min read
Master‑Slave Replication in Redis: Core Mechanics Explained and Production Deployment
YiSu Grain
YiSu Grain
Aug 10, 2026 · Databases

Choosing the Right NoSQL Model: From Four Data Types to CAP Trade‑offs

This article explains the four major NoSQL data models—key‑value, document, column‑family, and graph—detailing their structures, strengths, weaknesses, CAP trade‑offs, consistency options, and how to match each model to specific business queries and requirements, including polyglot persistence strategies.

CAPData ModelingNoSQL
0 likes · 29 min read
Choosing the Right NoSQL Model: From Four Data Types to CAP Trade‑offs
Architect's Tech Stack
Architect's Tech Stack
Aug 10, 2026 · Databases

Goodbye Navicat: Why the New Rust‑Based DBX Tool Is a Game‑Changer

The author, after a decade of Java backend work, compares the heavyweight Navicat and DBeaver with the lightweight 20 MB Rust‑built DBX client, highlighting its 70+ database support, zero‑install setup, advanced query editor, AI‑ready MCP server, and why it feels indispensable for backend and ops teams.

CodeMirrorDBXDatabase client
0 likes · 4 min read
Goodbye Navicat: Why the New Rust‑Based DBX Tool Is a Game‑Changer
SpringMeng
SpringMeng
Aug 10, 2026 · Databases

Exploring RedisInsight’s New Web UI: Stunning Visuals and Powerful Features

This article walks through RedisInsight’s newly released web version, showing how to deploy it with Docker, highlighting its intuitive UI for browsing and editing various Redis data types, built‑in workbench, slow‑log and memory analysis, multi‑model support, theme switching, and built‑in tutorials.

Database VisualizationDockerRedis
0 likes · 5 min read
Exploring RedisInsight’s New Web UI: Stunning Visuals and Powerful Features
Data STUDIO
Data STUDIO
Aug 10, 2026 · Databases

Master DuckDB: From Your First SQL Query to Analyzing Ten Million E‑Commerce Rows

This comprehensive DuckDB tutorial explains why loading large CSV files into Pandas is inefficient, demonstrates how DuckDB can query CSV, Parquet, and JSON directly, walks through SQL basics, advanced features like window functions and CTEs, compares performance against Pandas on ten‑million‑row datasets, and provides practical tips for tuning, common pitfalls, and when to choose DuckDB for data analysis.

BenchmarkDuckDBPandas
0 likes · 28 min read
Master DuckDB: From Your First SQL Query to Analyzing Ten Million E‑Commerce Rows
21CTO
21CTO
Aug 10, 2026 · Databases

Build a High‑Availability PostgreSQL Cluster with Streaming Replication and Read‑Write Splitting from Scratch

This guide walks through the complete process of designing, configuring, and operating a PostgreSQL primary‑standby setup with streaming replication, choosing between asynchronous and synchronous modes, implementing read‑write splitting via application routing or PgBouncer, and handling monitoring, failover, and common pitfalls for production‑grade high availability.

PatroniPostgreSQLRead Write Splitting
0 likes · 15 min read
Build a High‑Availability PostgreSQL Cluster with Streaming Replication and Read‑Write Splitting from Scratch
liandk
liandk
Aug 10, 2026 · Databases

INSERT Basics: A Beginner’s Hands‑On Guide to Adding Data

This tutorial explains the purpose of the SQL INSERT statement, compares column‑specified and full‑field syntax, shows single‑row and batch‑row examples using a UserInfo table, and highlights common pitfalls such as column‑value ordering, quoting rules, and auto‑increment IDs.

Data InsertionDatabaseINSERT
0 likes · 2 min read
INSERT Basics: A Beginner’s Hands‑On Guide to Adding Data
Cloud Architecture
Cloud Architecture
Aug 9, 2026 · Databases

Redis Persistence Deep Dive: From a Major P0 Outage to RDB+AOF Hybrid Implementation

The article analyses a real‑world P0 outage caused by treating Redis as a simple cache, explains why persistence is the decisive factor when Redis stores session, inventory or lock data, and provides a step‑by‑step guide to RDB, AOF and hybrid persistence, configuration, monitoring, recovery and best‑practice recommendations.

AOFHybrid PersistencePersistence
0 likes · 33 min read
Redis Persistence Deep Dive: From a Major P0 Outage to RDB+AOF Hybrid Implementation
YiSu Grain
YiSu Grain
Aug 8, 2026 · Databases

Day 51: Database Architecture – Master‑Slave Replication, Read‑Write Separation, Sharding & Consistency

The article walks through diagnosing database bottlenecks, explains MySQL replication flow, read‑write separation benefits and limits, shows when to apply vertical versus horizontal partitioning, details sharding‑key selection, cross‑shard challenges, high‑availability steps, and presents a complete e‑commerce case study.

Database ReplicationHorizontal PartitioningRead-Write Separation
0 likes · 29 min read
Day 51: Database Architecture – Master‑Slave Replication, Read‑Write Separation, Sharding & Consistency
Architect
Architect
Aug 8, 2026 · Databases

Ontology as the Semantic Control Plane for Agent Fact Systems

The article explains how an ontology—defining objects, relationships, constraints, and inferable boundaries within a domain—serves as a semantic control plane between the fact and action layers of an agent‑driven system, ensuring consistent interpretation, validation, and lifecycle management of business facts.

Data GovernanceGraph DatabasesRDF
0 likes · 18 min read
Ontology as the Semantic Control Plane for Agent Fact Systems
liandk
liandk
Aug 8, 2026 · Databases

SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)

This tutorial walks SQL newcomers through the three essential database commands—creating a database, listing all databases, switching to a specific one, and safely dropping a database—providing copy‑paste code, practical scenarios, and beginner‑focused pitfalls.

Beginner TutorialDatabase BasicsSQL
0 likes · 3 min read
SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)
Architect's Guide
Architect's Guide
Aug 8, 2026 · Databases

Why Do Indexes Speed Up Database Queries?

The article explains how database indexes, built on sorted data and binary search, dramatically reduce query time compared to full table scans, while also covering storage fundamentals, the cost of excessive indexes, clustered indexes, index failure scenarios, and practical SQL optimization techniques.

SQL optimizationbinary searchclustered index
0 likes · 12 min read
Why Do Indexes Speed Up Database Queries?