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
PostgreSQL CTEs and Recursive Queries for Hierarchical Data
Use PostgreSQL CTEs and recursive queries for category trees, graph traversal, and complex aggregations. Covers MATERIALIZED vs NOT MATERIALIZED and cycle prevention.
MySQL 8.0 Window Functions: ROW_NUMBER, LAG, LEAD, and Running Totals
Master MySQL 8.0 window functions for analytical queries. Covers ROW_NUMBER, RANK, LAG/LEAD for period comparison, running totals with SUM OVER, and NTILE quartiles.
MySQL InnoDB Redo Log Tuning: Sizing for Production Write Throughput
The InnoDB redo log default of 100MB is dangerously undersized for production. Learn to measure your write throughput, size innodb_redo_log_capacity correctly, and monitor checkpoint pressure before write stalls occur.
PostgreSQL WAL Configuration: fsync, synchronous_commit, and Checkpoint Tuning
Tune PostgreSQL 18 WAL and checkpoints without weakening crash safety: understand commit modes, measure checkpointer deltas, and validate archive recovery.
Database Disaster Recovery Runbook: RTO, RPO, and PITR Procedures
Build a production database DR runbook covering RTO/RPO definitions, failover steps, PITR recovery commands, and a verification checklist. Test it quarterly.
MySQL 8.4 Audit Log Filter: Selective Logging for Compliance
MySQL 8.4's audit log filter system lets you capture exactly the events your compliance framework requires — filtering by user, schema, event class, and severity to reduce audit log volume.
Multi-Region Database Architecture: Active-Passive, Aurora Global, and Read Routing
Design multi-region database topologies for global latency and DR. Compares active-passive, Aurora Global Database replication, and application-level read routing patterns.
Database CI/CD: Versioned Migrations, GitHub Actions, and Schema Testing
Implement database CI/CD with Flyway migrations, GitHub Actions pipelines, pytest schema tests, and blue-green deployment patterns. Eliminate ad-hoc schema changes.
PostgreSQL Database Hardening: A Security Best Practices Guide
A practical guide to hardening PostgreSQL: configure SSL/TLS, tighten pg_hba.conf, implement least-privilege roles, enable row-level security, and set up audit logging.
Mastering PostgreSQL Log Management: Configuration, Analysis, and Alerting
PostgreSQL's logging system is powerful but requires careful configuration to be useful in production. Learn how to capture slow queries, connection events, and DDL changes without drowning in noise.
Zero-Downtime PostgreSQL Major Version Upgrade with Logical Replication
Upgrade PostgreSQL major versions with sub-second downtime using logical replication. Step-by-step guide covering schema copy, subscription setup, lag monitoring, and sequence resync.
MySQL InnoDB Lock Monitoring: Detecting and Killing Blocking Transactions
Monitor InnoDB lock contention with performance_schema.data_locks, find blocking transactions, kill them safely, and prevent escalation with short transactions and proper timeouts.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed