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

Running Valkey on VMs: Clocksource, Huge Pages and a Latency Baseline

Set up a Valkey 9.1 VM host: check the clocksource behind the 9.1 clock bugs, set huge pages, swap, NUMA and IRQs, and record a latency baseline with --intrinsic-latency.

Redis18 minNov 8, 2026
Read

Kafka 4.0 Without ZooKeeper: KRaft Migration for CDC Pipelines

Move a ZooKeeper-mode Kafka cluster to Kafka 4.x through the 3.9 bridge: controller quorum design, migration phases, rollback points, and what to check in Debezium and Connect.

Kafka19 minNov 8, 2026
Read

Large Values and Tail Latency in Valkey: Reply Copy Avoidance and COMMANDLOG large-reply

Find out why multi-MB values raise p99.9 for every Valkey client, when 9.0 reply copy avoidance applies, what the COMMANDLOG large-reply log costs, and how to find and fix big values.

Redis21 minNov 7, 2026
Read

Multi-AZ Valkey: Replica Placement, Failover Priority and Zone-Aware Clients

Lay out self-managed Valkey Cluster and Sentinel across availability zones so a zone loss keeps a voting majority, a replica for every shard and a predictable failover.

Redis19 minNov 7, 2026
Read

Valkey Hash Field Expiration in Production: HSETEX, HGETEX, and HEXPIRE

Give single hash fields their own TTL on Valkey 9: the commands and versions, session, flag, and rate-counter patterns, the memory cost, replication, and the patch floor.

Redis19 minNov 7, 2026
Read

Valkey Connection Storms: maxclients, Client Eviction and Output Buffer Limits

An incident runbook for Valkey connection storms: read INFO clients and CLIENT LIST, size maxclients and file descriptors, shed clients safely, and bound client memory.

Redis20 minNov 7, 2026
Read

ProxySQL 3.0: PostgreSQL Support and What Changed for MySQL Users

Find out which ProxySQL 3.0 release to run, what its PostgreSQL support covers, what changed for MySQL users since 2.7, and how to upgrade a node or a cluster with a rollback point.

PostgreSQL20 minNov 7, 2026
Read

MySQL Shell Dump and Load Utilities vs mydumper

Compare MySQL Shell 26.10 dump and load with mydumper 1.0 on locking, chunking, managed targets, deferred indexes, resume, and GTIDs, with commands for each step.

MySQL17 minNov 7, 2026
Read

Planned Valkey Switchovers Without Client Errors: CLIENT CAPA REDIRECT and FAILOVER

Switch a standalone Valkey primary to a replica with FAILOVER, and use CLIENT CAPA redirect so clients follow the new primary instead of failing with READONLY.

Redis19 minNov 6, 2026
Read

Stopping Valkey Full-Resync Loops: Backlog Sizing and Dual-Channel Replication

Find out why Valkey replicas loop on full resyncs, size repl-backlog-size and the replica output buffer from your write rate, and decide when dual-channel replication helps.

Redis20 minNov 6, 2026
Read

Valkey BGSAVE Failures and Fork Latency: Overcommit, Huge Pages, and the 9.2 Forkless Option

Diagnose Valkey BGSAVE and MISCONF failures, size memory for fork copy-on-write, tune overcommit, THP and oom-score-adj, and trial 9.2 RC forkless snapshots.

Redis20 minNov 6, 2026
Read

Monitoring Valkey: Prometheus Metrics, COMMANDLOG, JSON Logs and the Alerts That Matter

Set up Valkey 9.1 monitoring with redis_exporter and Prometheus: the INFO fields that matter, COMMANDLOG and JSON logs, and starter alert rules with the reasoning behind each.

Redis19 minNov 6, 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