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