JusDB
Free DB Audit

The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

404 canonical articlesBrowse the complete archive

Popular Searches

Featured Articles

Hand-picked by our editors

Analytics & OLAP· Featured

StarRocks Monitoring & Alerting: The Complete Production Guide

Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.

StarRocks14 minMar 24, 2026
Read

Latest Articles

Showing 12 of 404 articles

MongoDB 8.0 TTL Index Bug (SERVER-97368): What It Is and How to Fix It

A critical bug in MongoDB 8.0 (SERVER-97368) affects TTL index behavior — causing documents to persist beyond expiration or delete prematurely. Here's how to detect and mitigate it.

MongoDB7 minDec 4, 2025
Read

MySQL JSON Column Performance: Indexing, Querying, and Schema Design Trade-offs

Understand when MySQL JSON columns help and hurt performance. Learn functional indexes, JSON_TABLE, and when to migrate JSON to normalized columns.

MySQL6 minDec 3, 2025
Read

AWS DMS Performance Tuning: Zero-Downtime Database Migration at Scale

AWS DMS can migrate terabytes of data with zero downtime — but default settings leave significant performance on the table. Here's how to tune DMS for production-grade migrations.

AWS10 minNov 29, 2025
Read

Database Migration Anti-Patterns: 5 Mistakes That Cause Production Incidents

Teams take down production for hours with migrations that could be zero-downtime operations. Learn to use gh-ost and CREATE INDEX CONCURRENTLY, implement rollback plans, and apply the expand-contract pattern for breaking changes.

PostgreSQL10 minNov 25, 2025
Read

MySQL Foreign Keys: Evolution from 5.7 to 8.4

MySQL's foreign key implementation has evolved significantly from 5.7 through 8.4 — with changes to metadata locking, instant DDL interactions, and Group Replication behavior that every DBA needs to understand.

MySQL8 minNov 20, 2025
Read

The 2026 Database Apocalypse: Why Your Database Might Explode (And How to Save It)

In 2026, more database versions are hitting end-of-life than any year in recent history.

8 minNov 18, 2025
Read

MySQL InnoDB Buffer Pool: Deep Dive into Pages, Chunks, and Eviction

Master InnoDB buffer pool internals: page management, chunk allocation, LRU algorithm, and tuning strategies for maximum cache efficiency.

MySQL9 minNov 17, 2025
Read

Redis Sentinel vs Redis Cluster: Choosing the Right HA Architecture

Redis Sentinel and Redis Cluster both provide HA, but teams regularly choose the wrong one. Sentinel is simpler and covers 95% of use cases; Cluster is required for horizontal scale. Here's when to choose each.

Redis9 minNov 11, 2025
Read

MySQL 8.0 Generated Columns: Virtual, Stored, and JSON Index Extraction

Use MySQL 8.0 generated columns to index computed values, JSON paths, and date parts. Covers virtual vs stored tradeoffs and functional index patterns.

MySQL1 minNov 10, 2025
Read

PostgreSQL Extensions Guide: pg_stat_statements, pg_trgm, pg_cron, and More

Survey essential PostgreSQL extensions: pg_stat_statements for query analysis, pg_trgm for fuzzy search, pg_cron for scheduled jobs, pg_buffercache for cache inspection.

PostgreSQL1 minNov 6, 2025
Read

Debezium 3.0: Real-Time CDC from PostgreSQL, MySQL, and MongoDB

Debezium 3.0 turns your database transaction log into a real-time event stream with full before/after row images. Learn to configure CDC for PostgreSQL WAL and MySQL binlog, avoid the offset storage trap, and monitor replication lag.

PostgreSQL4 minOct 28, 2025
Read

MySQL Optimizer Hints: INDEX, JOIN_ORDER, and MAX_EXECUTION_TIME

Guide MySQL query execution with optimizer hints. Covers INDEX, NO_INDEX, JOIN_ORDER, MAX_EXECUTION_TIME, and query block naming for subquery hint targeting.

MySQL5 minOct 27, 2025
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed