BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
MaGe Linux Operations
MaGe Linux Operations
Jul 14, 2026 · Databases

Common MySQL Connection Errors and Step‑by‑Step Troubleshooting Guide

MySQL connection failures are among the most frequent issues for developers and operators; this article systematically walks through typical error messages, explains how to collect relevant information, runs layered command checks, analyzes evidence, identifies root causes such as socket problems, bind‑address limits, host whitelist mismatches, authentication failures, connection‑limit exhaustion, and packet timeouts, and provides concrete fix and verification procedures for on‑premise, Docker, and Kubernetes deployments.

DockerLinuxMySQL
0 likes · 25 min read
Common MySQL Connection Errors and Step‑by‑Step Troubleshooting Guide
21CTO
21CTO
Jul 13, 2026 · Databases

How to Disable MySQL Binary Logging to Free Disk Space

The article explains why excessive MySQL binary logs filled a CentOS server’s disk, walks through cleaning unrelated logs, shows how to inspect and purge the binlog files, and provides the exact my.cnf changes needed to permanently disable binary logging.

CentOSConfigurationLaravel
0 likes · 7 min read
How to Disable MySQL Binary Logging to Free Disk Space
IoT Full-Stack Technology
IoT Full-Stack Technology
Jul 13, 2026 · Databases

Is Sharding Dead? A Technical Comparison with NewSQL Databases

The article objectively compares middleware‑based sharding with NewSQL distributed databases, examining distributed transactions, CAP constraints, HA, scaling, storage engines, maturity, and ecosystem, and offers a decision framework for choosing the appropriate architecture based on concrete requirements.

CAP theoremDatabase ArchitectureNewSQL
0 likes · 18 min read
Is Sharding Dead? A Technical Comparison with NewSQL Databases
dbaplus Community
dbaplus Community
Jul 12, 2026 · Databases

Stop Blaming Data Size: 90% of Slow SQLs Are Due to Poor Queries

This article reveals that most slow SQL queries aren't caused by large data volumes but by poor query writing, such as index‑killing functions, implicit type casts, leading wildcards, SELECT *, missing LIMIT, and inefficient JOINs, and offers a five‑step method to diagnose and fix them.

IndexingPerformanceSQL
0 likes · 11 min read
Stop Blaming Data Size: 90% of Slow SQLs Are Due to Poor Queries
Cloud Architecture
Cloud Architecture
Jul 12, 2026 · Databases

Database Performance Optimization: 100× Speed Gains Without Changing SQL

Even without rewriting any SQL, database performance can improve up to a hundredfold by first diagnosing bottlenecks, reducing unnecessary traffic, layering read paths, optimizing indexes, tuning connection pools, and progressively evolving from a single‑node setup to read‑write separation, sharding, and distributed read models.

CachingConnection PoolMySQL
0 likes · 38 min read
Database Performance Optimization: 100× Speed Gains Without Changing SQL
Ops Community
Ops Community
Jul 12, 2026 · Databases

Which MySQL Files Can Be Safely Deleted When Disk Space Is Low?

When MySQL runs out of disk space, the safest approach is to identify the full filesystem, examine data, binlog, temporary and log directories, and use SQL‑based cleanup commands like PURGE BINARY LOGS while never manually removing critical files such as ibdata1, ib_logfile* or active binlogs.

BackupInnoDBMySQL
0 likes · 16 min read
Which MySQL Files Can Be Safely Deleted When Disk Space Is Low?
Java Companion
Java Companion
Jul 12, 2026 · Databases

Forget Navicat: How an AI‑Powered SQL Chat Tool Writes Queries for You

SQL Chat, an open‑source AI‑driven database client with 5.8K stars, lets you converse in natural language to generate and run SQL across MySQL, PostgreSQL, MSSQL, TiDB Cloud and OceanBase, while keeping data local and offering Docker self‑hosting, but it still cannot replace full‑featured tools for complex tasks.

AI SQL clientDatabase explorationDocker
0 likes · 10 min read
Forget Navicat: How an AI‑Powered SQL Chat Tool Writes Queries for You
Shuge Unlimited
Shuge Unlimited
Jul 12, 2026 · Databases

Milvus 3.0 Streaming Architecture: 16 PChannels, Five Interceptor Layers, and a Self‑Built WAL 5.8× Faster Than Kafka

Milvus 3.0 replaces the dual‑track write path of 2.x with a unified WAL‑first design, introduces a three‑layer channel model (PChannel, VChannel, CChannel) and a five‑layer interceptor chain, adds the Woodpecker WAL that outperforms Kafka/Pulsar by up to 5.8×, and provides pluggable back‑ends, atomic broadcasting, and provable recovery mechanisms.

DatabaseDistributed SystemsMilvus
0 likes · 27 min read
Milvus 3.0 Streaming Architecture: 16 PChannels, Five Interceptor Layers, and a Self‑Built WAL 5.8× Faster Than Kafka
Raymond Ops
Raymond Ops
Jul 11, 2026 · Databases

How to Diagnose and Optimize Production Database Connection Pool Exhaustion

This article walks through the principles of database connection pools, common causes of pool exhaustion such as leaks, mis‑configuration, slow SQL and DB limits, and provides a step‑by‑step methodology with monitoring, thread‑stack analysis, and concrete configuration and SQL optimizations to restore stability.

Connection PoolHikariCPJava
0 likes · 29 min read
How to Diagnose and Optimize Production Database Connection Pool Exhaustion
ITPUB
ITPUB
Jul 9, 2026 · Databases

Why Valkey Overtook Redis After the License Change: A Deep Dive

After Redis switched from a BSD to a closed‑source license in March 2024, the community quickly forked Valkey, which within a year surpassed Redis in throughput, latency, and memory usage, gained support from major cloud providers and Linux distributions, and continues to accelerate while Redis struggles to regain its position.

Cloud cachingDatabase forkOpen source licensing
0 likes · 12 min read
Why Valkey Overtook Redis After the License Change: A Deep Dive
Yumin Fish Harvest
Yumin Fish Harvest
Jul 9, 2026 · Databases

Redis Pipeline, Transactions, Lua, Distributed Locks, Streams & Data Types

This article provides an in‑depth guide to Redis’s advanced capabilities, covering how to use pipeline for batch commands, transactions for ordered execution, Lua scripts for atomic logic, distributed locks with proper token handling, reliable messaging with streams, and specialized data structures such as BitMap, HyperLogLog, Bloom Filter and GEO for efficient large‑scale scenarios.

Bloom FilterDistributed LockGEO
0 likes · 65 min read
Redis Pipeline, Transactions, Lua, Distributed Locks, Streams & Data Types
Java Architect Essentials
Java Architect Essentials
Jul 8, 2026 · Databases

Can SQLark Replace Navicat and DBeaver? An AI‑Powered Domestic DB Tool That Boosts Developer Productivity

The article reviews SQLark, a Chinese one‑stop database development and management tool that supports Windows, macOS, and Linux, connects to major databases such as Oracle, MySQL and PostgreSQL, and integrates AI assistance, positioning it as a convenient, efficient alternative to Navicat and DBeaver.

AI assistantData MigrationDatabase Management
0 likes · 7 min read
Can SQLark Replace Navicat and DBeaver? An AI‑Powered Domestic DB Tool That Boosts Developer Productivity
ITPUB
ITPUB
Jul 8, 2026 · Databases

MySQL 26.7 EA Arrives: Calendar Versioning Jumps to 26 and Community Edition Evolves

MySQL 26.7.0 Early Access introduces calendar versioning that jumps the version number to 26, adds post‑quantum TLS support, a new Change Stream Applier, InnoDB refactoring, and moves the thread‑pool plugin to the community edition, while Oracle expands governance with a steering committee, a public roadmap, and a detailed release schedule for 2026‑2027.

Calendar VersioningChange Stream ApplierDatabase Governance
0 likes · 16 min read
MySQL 26.7 EA Arrives: Calendar Versioning Jumps to 26 and Community Edition Evolves
Cloud Architecture
Cloud Architecture
Jul 7, 2026 · Databases

MySQL User & Permission Management: From Grant Statements to Production-Grade Security Architecture

This comprehensive guide explains why MySQL permission mistakes happen, walks through the authentication and authorization process, shows how to design multi‑layered user models, role hierarchies, declarative GitOps workflows, Kubernetes integration, and production‑ready automation for secure, auditable, and scalable database access.

GitOpsMySQLPermission
0 likes · 42 min read
MySQL User & Permission Management: From Grant Statements to Production-Grade Security Architecture
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Redis High‑Availability Deep Dive: Master‑Slave Replication, Sentinel, and Split‑Brain Protection

This article explains why a single‑node Redis deployment is a single‑point‑of‑failure and walks through building a highly available Redis cluster using master‑slave replication, Sentinel monitoring and automatic failover, split‑brain prevention, production deployment guidelines, common pitfalls, and client‑side connection strategies.

ConfigurationDatabaseFailover
0 likes · 36 min read
Redis High‑Availability Deep Dive: Master‑Slave Replication, Sentinel, and Split‑Brain Protection
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Understanding Redis Persistence: RDB, AOF, Hybrid Persistence and Redis 7 Multi‑Part AOF

A power outage once erased all cached sessions, counters and leaderboards in Redis, exposing the inherent risk of in‑memory data loss and prompting a deep dive into Redis persistence mechanisms—RDB snapshots, AOF command logging, their trade‑offs, hybrid persistence, and the new Redis 7 Multi‑Part AOF design—so you can choose the right strategy for your workload.

ConfigurationReplicationaof
0 likes · 37 min read
Understanding Redis Persistence: RDB, AOF, Hybrid Persistence and Redis 7 Multi‑Part AOF
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Redis Performance Secrets: How Data Types and Internal Encodings Boost Speed

This article explains why Redis can store one million items with ten‑fold memory savings by examining each of the five core data types, their underlying encodings such as SDS, listpack, quicklist, hashtable and skiplist, and shows how automatic encoding switches affect memory usage, performance, and common pitfalls.

Data StructuresEncodingE‑Commerce
0 likes · 42 min read
Redis Performance Secrets: How Data Types and Internal Encodings Boost Speed
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Step-by-Step Redis Setup from Scratch: Docker, Docker Compose, Master‑Slave, Sentinel, and Cluster

This tutorial walks a complete beginner through launching a Redis server with Docker, managing it with Docker Compose, adding master‑slave replication, configuring Sentinel for automatic failover, building a 3‑master‑3‑replica Redis Cluster, and provides production‑grade configuration templates and an online‑deployment checklist.

BackupDockerDocker Compose
0 likes · 40 min read
Step-by-Step Redis Setup from Scratch: Docker, Docker Compose, Master‑Slave, Sentinel, and Cluster