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

Resharding Valkey 9 with Atomic Slot Migration: A Production Runbook

Reshard a Valkey 9 cluster with atomic slot migration: how it differs from MIGRATE, the checks to run first, how to monitor and cancel a move, and a batch runbook with rollback.

Redis18 minOct 30, 2026
Read

Sizing Valkey io-threads: A Measurement-Based Method for 9.1

Size Valkey io-threads by measurement: what I/O threads offload, how to read the 9.1 active-time counters, a step-by-step benchmark method, and when more threads hurt.

Redis20 minOct 30, 2026
Read

Cassandra nodetool repair: Full vs Incremental, and Scheduling with Reaper

Run Cassandra 4.1 and 5.0 repairs that finish inside gc_grace_seconds: full vs incremental, -pr and subranges, parallelism, Reaper schedules, the built-in auto repair, and failed repairs.

Cassandra18 minOct 30, 2026
Read

MySQL 26.7 and Calendar Versioning: Which MySQL Should You Run Now?

Learn how MySQL 26.7 and 26.10 calendar versions work, how LTS and Innovation tracks differ, which upgrade paths are allowed, and which MySQL version to run in 2026.

MySQL18 minOct 30, 2026
Read

How Long Does a Valkey Cluster Failover Take? Node Timeout, Elections and Graceful Shutdown

Work out how long a Valkey Cluster failover takes on 8.0 to 9.1, tune cluster-node-timeout with its trade-offs, and hand primaries off on SIGTERM or SHUTDOWN FAILOVER.

Redis20 minOct 29, 2026
Read

MySQL INSTANT DDL: What Is Instant and What Still Copies the Table

Learn which ALTER TABLE changes are instant on MySQL 8.4 and 9.7, how to make MySQL refuse a silent table copy, and how to avoid metadata lock pileups.

MySQL18 minOct 29, 2026
Read

MySQL Clone Plugin: Provisioning Replicas Without a Backup Restore

Provision a MySQL 8.4 replica with the clone plugin: prerequisites, privileges, DDL and bandwidth settings, progress monitoring, and GTID replication after the clone.

MySQL18 minOct 29, 2026
Read

Valkey Backups and Restore Drills: RDB, Multi-Part AOF and Cluster Recovery

Take Valkey backups you can restore: RDB and multi-part AOF copies, per-shard cluster snapshots, the appendonly yes restore trap, file checks, and timed drills.

Redis19 minOct 28, 2026
Read

Sentinel on Valkey 9: Coordinated Failover and the ACL Change That Broke Failovers

Fix the Valkey 9.0.0 Sentinel ACL regression, set the right Sentinel ACL for 9.x, use coordinated failover safely, and upgrade Sentinel from 7.2 or 8.x to 9.1.

Redis19 minOct 28, 2026
Read

Migrating Redis OSS to Valkey on AWS: ElastiCache and MemoryDB Runbook

Move ElastiCache and MemoryDB from Redis OSS to Valkey: prerequisites, parameter groups, client checks, reserved nodes, and why only Valkey 7.2 can roll back to Redis OSS 7.1.

Redis18 minOct 28, 2026
Read

MySQL Invisible Indexes: Drop an Index Safely

Test an index drop on MySQL 8.4 before you commit to it: find unused candidates on every server, hide one with ALTER INDEX INVISIBLE, compare plans, and drop it with a rollback.

MySQL18 minOct 28, 2026
Read

MySQL Histograms: When the Optimizer Needs Them

Learn when a MySQL histogram beats an index, how to build one with ANALYZE TABLE, how to read its effect in EXPLAIN, and how to keep it fresh with AUTO UPDATE.

MySQL20 minOct 28, 2026
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