BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
liandk
liandk
Sep 15, 2026 · Databases

MySQL MGR Cluster: Paxos Consensus, Zero-Downtime HA & Brain-Split Proof Architecture

This article explains MySQL Group Replication (MGR), a native high-availability cluster based on Paxos consensus, covering its architecture, single-primary vs multi-primary modes, automatic failover, brain-split prevention via majority voting, production deployment rules, and common pitfalls to avoid for zero-data-loss transactional systems.

Brain SplitDatabase ClusteringGroup Replication
0 likes · 12 min read
MySQL MGR Cluster: Paxos Consensus, Zero-Downtime HA & Brain-Split Proof Architecture
Shuge Unlimited
Shuge Unlimited
Sep 14, 2026 · Databases

Milvus 3.0 Upgrade Is Easy, Rollback Is the Real Danger

This article analyzes why rolling back a Milvus 3.0 upgrade is far riskier than the upgrade itself, explaining how Storage V3, index version changes, WAL message semantics, and SDK/proto contracts create irreversible state boundaries that a simple image tag revert cannot undo.

CompactionLoon FFIMilvus
0 likes · 21 min read
Milvus 3.0 Upgrade Is Easy, Rollback Is the Real Danger
Lobster Programming
Lobster Programming
Sep 14, 2026 · Databases

Three-Field Schema for Encrypted Phone Number Queries by Last Four Digits

The article analyzes flawed approaches for querying encrypted phone numbers by last four digits — memory decryption, ciphertext fuzzy matching, partial encryption, and mapping tables — and presents a three-field design (full ciphertext, masked display, indexed last-four plaintext) that ensures compliance, security, and millisecond query performance at million-user scale.

AES-256Database IndexingSM4
0 likes · 6 min read
Three-Field Schema for Encrypted Phone Number Queries by Last Four Digits
Java Tech Enthusiast
Java Tech Enthusiast
Sep 13, 2026 · Databases

MySQL 9.0 GA: JSON Multi-Valued Indexes, Parallel Query V2, and AI Optimizer Deep Dive

MySQL 9.0 introduces three major features: native JSON multi-valued indexes delivering 370x faster array queries, Parallel Query V2 with work-stealing achieving 7-8x speedups on analytical workloads, and an ML-based AI query optimizer that cuts index misselection from 12% to 2% and boosts complex query performance by 25-40%.

AI query optimizerJSON multi-valued indexMySQL 9.0
0 likes · 11 min read
MySQL 9.0 GA: JSON Multi-Valued Indexes, Parallel Query V2, and AI Optimizer Deep Dive
MaGe Linux Operations
MaGe Linux Operations
Sep 11, 2026 · Databases

MySQL Slow Query Mastery: From Log Analysis to Index Optimization

This comprehensive guide walks through the complete MySQL slow query troubleshooting loop: enabling slow query logs, analyzing with mysqldumpslow and pt-query-digest, using EXPLAIN to identify missing indexes or inefficient plans, designing composite indexes following leftmost prefix principles, validating in test environments, and safely deploying changes in production with rollback plans.

EXPLAINIndex OptimizationInnoDB
0 likes · 52 min read
MySQL Slow Query Mastery: From Log Analysis to Index Optimization
liandk
liandk
Sep 11, 2026 · Databases

MySQL Master-Slave Replication: Sync Principles, Delay Fixes, Read-Write Splitting & Failover

This article provides a comprehensive practical guide to MySQL master-slave replication, covering synchronization principles, three replication modes, delay causes and troubleshooting, read-write splitting implementation with common pitfalls, failover strategies, and five production pitfalls to avoid.

Database High AvailabilityDatabase ReplicationMaster-Slave Replication
0 likes · 12 min read
MySQL Master-Slave Replication: Sync Principles, Delay Fixes, Read-Write Splitting & Failover
Lakehouse Research Base
Lakehouse Research Base
Sep 10, 2026 · Databases

Apache Fluss Virtual Tables: $changelog vs $binlog for Queryable Change Streams

This article deep-dives into Apache Fluss virtual tables, explaining how $changelog and $binlog suffixes expose change logs as read-only queryable tables, detailing their schemas, use cases, differences between PrimaryKey and Log tables, startup modes, limitations, and the design philosophy enabling native CDC consumption via SQL without external tools.

Apache FlussBinlogCDC
0 likes · 9 min read
Apache Fluss Virtual Tables: $changelog vs $binlog for Queryable Change Streams
dbaplus Community
dbaplus Community
Sep 8, 2026 · Databases

Why LLM-Generated SQL Fails in Production: A Three-Layer Architecture for Reliable Text-to-SQL

The article explains why directly using LLMs to generate SQL leads to sub-50% accuracy in production, and presents a proven three-layer architecture—semantic layer for business knowledge, LLM layer for structured DSL generation, and deterministic execution layer for dialect-specific SQL translation—that achieves 85-90% accuracy through RAG, ambiguity detection, and feedback loops.

DSLDatabase DialectsLLM
0 likes · 15 min read
Why LLM-Generated SQL Fails in Production: A Three-Layer Architecture for Reliable Text-to-SQL
Programmer XiaoFu
Programmer XiaoFu
Sep 8, 2026 · Databases

Why MySQL Still Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC mechanism uses version chains and ReadViews to enable lock-free snapshot reads, and why four isolation levels (READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE) are still necessary: they define when ReadViews are created, controlling which version a transaction sees, while MVCC only handles reads—writes still require row locks.

Concurrency ControlInnoDBMVCC
0 likes · 9 min read
Why MySQL Still Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 8, 2026 · Databases

10 Essential MySQL Configuration Settings for Performance Optimization

This article outlines ten critical MySQL configuration parameters administrators should prioritize after installation, covering InnoDB buffer pool sizing, log file configuration, connection limits, flush methods, query cache disabling, binary logging, and DNS resolution skipping, with practical guidance on safe modification practices and version-specific considerations.

Database ConfigurationInnoDBinnodb_buffer_pool_size
0 likes · 10 min read
10 Essential MySQL Configuration Settings for Performance Optimization
ITPUB
ITPUB
Sep 7, 2026 · Databases

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

This article explains InnoDB's checkpoint mechanism, contrasting synchronous and fuzzy checkpoints, detailing the pre-MySQL 8.0 fuzzy checkpoint implementation using flush lists and page cleaners, and describing two principles for detecting abnormal shutdowns plus four post-restart crash scenarios with their recovery requirements.

CheckpointCrash RecoveryInnoDB
0 likes · 11 min read
InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios
Tech Musings
Tech Musings
Sep 7, 2026 · Databases

MySQL Subquery Column Name Escaping: Silent Full-Table Update/Delete Risk

MySQL silently resolves missing column names in subqueries to outer scope columns, turning filters into correlated subqueries that always evaluate true, causing full-table updates or deletes without errors or warnings; no sql_mode prevents this behavior.

Best Practicescolumn resolutioncorrelated subquery
0 likes · 10 min read
MySQL Subquery Column Name Escaping: Silent Full-Table Update/Delete Risk
liandk
liandk
Sep 7, 2026 · Databases

MySQL MVCC Deep Dive: Lock-Free Reads, Isolation Levels & Phantom Read Mechanics

This article explains MySQL's MVCC mechanism in InnoDB, detailing how hidden fields, undo logs, and Read Views enable lock-free snapshot reads, the differences between RC and RR isolation levels, why MVCC prevents non-repeatable reads but not phantom reads, and common pitfalls like long transactions causing undo log bloat.

InnoDBMVCCPhantom Read
0 likes · 11 min read
MySQL MVCC Deep Dive: Lock-Free Reads, Isolation Levels & Phantom Read Mechanics
Smart Sea Tide
Smart Sea Tide
Sep 7, 2026 · Databases

Data Governance: 12 Brutal Truths Behind Common Excuses

This article dismantles twelve common data governance fallacies — from demanding instant metadata completion to treating governance as a cost center — arguing that effective governance requires confronting upstream data pollution, aligning incentives across departments, and prioritizing critical data paths over blanket coverage.

data governancedata lakedata lineage
0 likes · 10 min read
Data Governance: 12 Brutal Truths Behind Common Excuses
liandk
liandk
Sep 6, 2026 · Databases

MySQL Transaction Isolation Levels & Lock Mechanisms: Dirty Reads, Phantom Reads, Deadlocks Explained

This comprehensive guide explains MySQL transaction isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) and lock mechanisms (table, row, gap, next-key locks), demonstrating how dirty reads, non-repeatable reads, and phantom reads occur, with practical deadlock prevention strategies and enterprise-level isolation level selection guidelines.

ACIDGap LockLock Mechanisms
0 likes · 12 min read
MySQL Transaction Isolation Levels & Lock Mechanisms: Dirty Reads, Phantom Reads, Deadlocks Explained