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
Valkey vs Memcached in 2026: Threads, Memory Overhead, and When Each Fits
Compare Valkey 9.1 and Memcached 1.6.45 on threading, memory per key, eviction, persistence, replication, and ElastiCache support, then benchmark both with memtier_benchmark.
Valkey Cluster vs Sentinel: Choosing an HA Topology
Decide between Valkey Sentinel and Valkey Cluster on Valkey 9: data size limits, hash tags, numbered databases, client support, failover timing, and a migration runbook.
PostgreSQL Lock Waits: How to Find the Blocking Query and Fix It
Find the session behind a PostgreSQL lock wait with pg_blocking_pids, see why a waiting ALTER TABLE stalls every SELECT, and choose between cancel, terminate, and timeouts.
PostgreSQL Advisory Locks: Patterns and Pitfalls
Use PostgreSQL advisory locks safely: session vs transaction locks, key choice, singleton jobs, leader election, and the PgBouncer, LIMIT, and lock-table traps.
PostgreSQL BRIN Indexes for Time-Ordered Tables
Decide when a BRIN index can replace a B-tree on a time-ordered PostgreSQL table: check correlation, choose pages_per_range and an operator class, and roll it out safely.
PostgreSQL pg_stat_io: Reading I/O by Backend Type
Use pg_stat_io in PostgreSQL 16 to 18 to see whether client backends or the checkpointer do the writes, and to measure ring buffer, vacuum, extend, and WAL I/O.
MongoDB Change Streams in Production: Resume Tokens and the Oplog Window
Run MongoDB change streams in production: store resume tokens durably, size the oplog window, recover from ChangeStreamHistoryLost, and choose updateLookup or pre-images.
MongoDB Oplog Sizing and the Replication Window
Measure your MongoDB oplog window and write churn, find what fills the oplog, size it with a worked example, and resize it safely on every member or on Atlas.
ClickHouse Dictionaries: Replacing JOINs with In-Memory Lookups
Replace ClickHouse dimension JOINs with dictionaries: choose a layout, set LIFETIME refresh, use dictGet or a direct JOIN, size memory, and catch failed reloads.
MongoDB WiredTiger Cache Tuning: Eviction, Dirty Data, and Memory Limits
Size the MongoDB WiredTiger cache for VMs and containers, read the eviction thresholds in serverStatus, and decide when to resize the cache and when to fix queries and indexes.
SQL Server 2025 for DBAs: Features That Change Day-to-Day Operations
See what SQL Server 2025 changes for DBAs: optimized locking, tempdb caps, ZSTD and immutable backups, AG changes, breaking changes, and a safe compatibility level 170 rollout.
OpenSearch on Kubernetes with the OpenSearch Operator
Deploy OpenSearch on Kubernetes with operator 3.0.0: design node pools, size heap against memory limits, set up TLS, run rolling upgrades, and back up to S3.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed