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

Upgrading MySQL 8.4 LTS to 9.7 LTS: Path, Checks, and Rollback

Plan a MySQL 8.4 to 9.7 LTS upgrade: the supported path, the 9.0 to 9.6 removals to fix first, the upgrade checker run, a replica-first cutover, and rollback limits.

MySQL19 minOct 22, 2026
Read

MySQL 8.4 Authentication Errors: mysql_native_password and caching_sha2_password Fixes

Fix MySQL 8.4 authentication errors: why mysql_native_password is not loaded, what caching_sha2_password needs, which drivers work, and how to migrate before 9.x.

MySQL20 minOct 21, 2026
Read

Barman vs pgBackRest vs WAL-G for PostgreSQL Backup

Compare Barman, pgBackRest, and WAL-G as of November 2026: maintenance status, PostgreSQL 17 incremental support, WAL archiving, retention, Kubernetes operators, and a PITR drill.

PostgreSQL17 minOct 19, 2026
Read

MongoDB 9.0: What Changed and How to Upgrade from 8.0

Plan a MongoDB 8.0 to 9.0 upgrade: the behavior changes to test, driver minimums, the rolling order for replica sets and sharded clusters, and how far FCV lets you roll back.

MongoDB18 minOct 15, 2026
Read

Amazon Timestream in 2026: LiveAnalytics vs Timestream for InfluxDB

See what changed for Timestream for LiveAnalytics, compare Timestream for InfluxDB 2 and 3, map dimensions to tags, and plan a tested migration off LiveAnalytics.

AWS20 minOct 14, 2026
Read

PostgreSQL 14 EOL: Upgrade before November 12, 2026

PostgreSQL 14 reaches community end of life on November 12, 2026. Build an upgrade plan with compatibility checks, a rehearsed cutover, and clear rollback limits.

PostgreSQL14 minOct 6, 2026
Read

Redis architecture explained: From event loop to Cluster

How Redis works inside: one main thread and its event loop, I/O threads, memory encodings, eviction, RDB and AOF persistence, replication, Sentinel, and Cluster.

Redis16 minOct 2, 2026
Read

StarRocks 4.1: Adaptive Tablets, Range Distribution, and the Upgrade Trade-Offs

StarRocks 4.1 makes tablet layout adaptive: Range distribution, automatic splitting at 10 GB, and 100 GB tablets. When to enable it, and what it costs.

StarRocks13 minAug 3, 2026
Read

PostgreSQL 19 Beta: Every New Feature That Matters to DBAs

PostgreSQL 19 Beta 1 (June 4, 2026) brings parallel autovacuum, the native REPACK command for online table rebuilds, 2x faster inserts under foreign-key load, online logical replication without a restart, WAIT FOR LSN for read-your-writes consistency, and default changes (JIT off, lz4 TOAST, RADIUS removed). A DBA-focused walkthrough of what changed and what to test before GA.

PostgreSQL14 minJun 15, 2026
Read

High Performance with MongoDB: A Top-Down Tuning Guide

A top-down playbook for high-performance MongoDB: measure with the profiler and explain(), model for access patterns, index by the ESR rule, keep the working set in the WiredTiger cache, pool connections, and scale reads with secondaries and sharding — with flow diagrams for each layer.

MongoDB14 minJun 6, 2026
Read

Migrate On-Premises SQL Server to Amazon RDS: Native Backup/Restore vs AWS DMS

A step-by-step guide to migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server — covering native backup/restore via S3 with the rds_restore_database stored procedure, AWS DMS full-load + CDC for near-zero downtime, option group and IAM setup, cutover, and post-migration hardening.

AWS15 minJun 2, 2026
Read

PostgreSQL Performance Tuning Playbook: A Top-Down Method for Faster Queries

A repeatable, top-down method for tuning PostgreSQL: measure with pg_stat_statements, read plans with EXPLAIN (ANALYZE, BUFFERS), fix queries and indexes before parameters, then tune memory, I/O, WAL, connection pooling, and autovacuum — with a ready-to-adapt postgresql.conf baseline.

PostgreSQL22 minMay 31, 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