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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed