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.
Popular Searches
Featured Articles
Hand-picked by our editors
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed